if your form is bound to a table, query or SQL statement, then normally it
will show the first record when you open it. if you want to always open to a
blank "new" record, either set the form's DataEntry property to Yes, or add
an event procedure to the form's OnOpen event, as
Private Sub Form_Open(Cancel As Integer)
DoCmd.RunCommand acCmdRecordsGoToNew
End Sub
hth
Ask a Question
Want to reply to this thread or ask your own question?
You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.