Sub form visible in Form needs to hide previous entries

[clloyd]

I have a form that opens with an embedded subform visible for data entry of new data only. The form is based of a select query so I can show data from multiple tables for verification but the sub forms data is the actual table. I need the sub form to open with a blank record. I do not want to show previous entries because this is to be used to add new records only and not edit anything. Can anyone help.

[FishVal]

Hello, clloyd.

In a case you subform's source object is another form you could set DataEntry property of this form to True (either in design or dynamically via code) thus allowing user to make new records only.

Regards,
Fish.

[clloyd]

Form is Data Entry No or the Sub Form does not show up. The sub form is Data Entry Yes but it still shows all entries for a particular location although I have the sub form set to No Edits. You can only make additions.

[NeoPa]

From Access Help :

DataEntry Property

You can use the DataEntry property to specify whether a bound form opens to allow data entry only. The Data Entry property doesn't determine whether records can be added; it only determines whether existing records are displayed.
Read/write Boolean.

I don't understand what you're trying to say, but it doesn't seem to add up.

Perhaps you could explain exactly what's happening a little more clearly.

[clloyd]

Ok I will try to clerify

I have a form that could potentially have 1,000 clients. Each client could have 10 entries for dates of activity, which are listed in a sub form that appears on the main so the user things it is all one record not realizing they are stored in two different tables. They appear to be one form. The problem is I do not want to show all 10 entries in the sub form but provide just a blank record so they can add the latest activity only.

Does that help?

[NeoPa]

Perhaps you could explain exactly what's happening a little more clearly.

That was helpful, as it confirmed my previous understanding of your original question.

However, I was asking for clarification of your post #3, where you indicated you'd tried the solution proposed, but so vaguely that it was not possible to determine exactly what you had tried nor what results you'd found on trying it. When describing a situation including two forms, it can be confusing to explain something relative to Form.

[clloyd]

Sorry, the main form, which used to show the detail of the location only (city state etc) is set to data entry no. The subform which is used to log all the activity for the location is set to data entry yes. I do not want them to edit the sub form at all just add new activity only.

I hope this answers the question.

[NeoPa]

Well, I can't see why you could see any existing entries on the sub-form if its Data-Entry property is set to Yes. That doesn't make sense to me.