Not show first record when form is opened

[mutiger83]

Is there anyway to not have the first record automatically displayed when an MS Access form is opened? I would like the user to be able to move between records on the table, but would like it if it was just blank when the form was opened, instead of the first record.

Thanks!

 

[fneily]

I'll assume that the table has a primary key. Create a new record by typing a 0 in the primary key field and leave all the other fields blank. When you open the form, it'll start on this record.
Strange request.

 

[petrosky]

Hi,

In your forms "On Open" event you can have...

DoCmd.GoToRecord , , acNewRec

This will take you to a new record.

Peter.


Remember- It's nice to be important,
but it's important to be nice