Getting my text box to show an empty record on open

[jmo]

access 2003, i have a basic form with text boxes tied to a table that will be
be storing the data typed in the form. currenly when i populate the fields
and hit my command button for add record it moves that data to the table
etc....however when i reopen the form it is showing the last updated record
in each field or text box i wanted to see if there was a way to have the text
box so the next empty record of the table?

 

[Dirk Goldgar]

access 2003, i have a basic form with text boxes tied to a table that will
be
be storing the data typed in the form. currenly when i populate the fields
and hit my command button for add record it moves that data to the table
etc....however when i reopen the form it is showing the last updated
record
in each field or text box i wanted to see if there was a way to have the
text
box so the next empty record of the table?

If you set the form's Date Entry property to Yes (on the Data tab of the
form's property sheet in design view), then the form will open to a new
record by default.

 

[jmo]

that worked....Thanks Dirk
--
Jeremy Morton

If you set the form's Date Entry property to Yes (on the Data tab of the
form's property sheet in design view), then the form will open to a new
record by default.

--
Dirk Goldgar, MS Access MVP
www.datagnostics.com

(please reply to the newsgroup)