Open a form and see blank record for data entry

[mslennb]

How do I create a form so that it opens to a blank form and ready for data entry? The users should only see the data they are entering. The form consists of a main form and sub form. Both should be blank when the form is opened.
Thanks.

 

[AmigoMobility]

One way to to open the form like this:
DoCmd.OpenForm frmname, , , , acFormAdd

Another way is to go to the Forms properties and under the 2nd tab (Data) change Data Entry to "Yes" Doing this will always open the form to a new record and may not be what you want to do.

HTH,
Shane

 

[TheAceMan1]

. . . or in form design view, default the forms [blue]Data Entry[/blue] property to [blue]Yes![/blue]

See Ya! . . . . . .

Be sure to see thread181-473997

 

[mslennb]

Thanks. It worked!

 

[AmigoMobility]

Your welcome. Glad we could help.

Shane