In Access, is there a way to get a form to open to a blank record.

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I want to have my form open to a blank record, rather than open to the first
record in the database. Is this possible and how do you do it? Thanks!
 
Go to the Form Properties, click on Event, click the ... beside ON OPEN,
click on macro, in the macro box click GO TO RECORD, then at the bottom click
record=NEW
 
Set the form property 'Data Entry' to Yes. This will show a blank a
record. Or, you could add the following code to the form:

Private Sub Form_Load()

DoCmd.RunCommand acCmdRecordsGoToNew

End Sub
 
Back
Top