Search code examples
ms-access

Default to New Record when opening Form - Access

When opening a Form I would like it default to a blank record for data entry.

I tried changing "Data Entry" to "Yes" but I would still like to view other records.

How can I open a Form and have it default to a New/Blank Record but still allow me to go through other records?

Solution

  • Use the form load event:

    Private Sub Form_Load()
    DoCmd.GoToRecord , , acNewRec
End Sub