How do I suppress the display of the first record data in database on open of my form

[Jimcb8]

It is very confusing to my users when they open a form and the fields have data in them from the first record of the database. Can this be suppressed as if it was a form for data entry?
Any help will be greatly appreciated.

Thanks,
Jim

 

[pbaldy]

How about setting the form's Data Entry property to Yes?

 

[Jimcb8]

The form opened is an update subform opened by a navigation tab.
The subform has a combo box to select the client you wish to update. Changing the data entry to "yes" did not allow the client's fields to be filled by the record selected to be updated.

When the update Client form is first displayed on open, the combo box is blank ready for the user to choose the record to be updated. While the combo box is blank the other fields unfortunately on the form show the data of the first record in the database.

This is more of an ease of use problem then an actual bug in the system. It would be nice to have the combo box blank and the other fields blank ,as well, on open.

Your thoughts are always appreciated.

 

[Galaxiom]

Use the Open Event Procedure to move to the New Record.

DoCmd.GoToRecord , , acNewRec

DoCmd.GoToRecord

 

[godknow]

Use the Open Event Procedure to move to the New Record.

DoCmd.GoToRecord , , acNewRec

DoCmd.GoToRecord

thanks got it worked finally.