Open to an empty "new" record?

[Guest]

Having built a data entry form with command buttons including "add new
record" I woudl now like the form to open to a blank "new" record rather than
always opening up to the first record in the database. Anyone have the
answer? Thank you.

 

[Arvin Meyer]

Change the Data Entry property from No to Yes on the property sheet. You can
also open the form in code using:

DoCmd.OpenForm "MyFormName", , , , acFormAdd
--
Arvin Meyer, MCP, MVP
Microsoft Access
Free Access Downloads
http://www.datastrat.com
http://www.mvps.org/access

 

[Guest]

On the open event of the form you can either put in the following code:

DoCmd.GoToRecord , , acNewRec

OR

You could make a call to the click event of the command button Add new
record that you have on the form.

Steve Huff
http://www.huffs.us

 

[Guest]

Works like a charm and humbles me even more...Thank you.

 

[Guest]

Thanks for this! Have been scratching my head to get this to work as our
Fire Department database always opened to the first record and lots of people
accidentally start to enter information overwriting the first record. This
tip fixed our problem!