Opening a Form at a new Record

Opening a Form at a new Record

There are a couple of ways, depending on how you want your input forms to behave after they've been opened. If you only want to enter records, then in the code to open the form, put this code:

DoCmd.OpenForm "frmName", acNormal, ,acFormAdd

If you want to be able to navigate to other records in the form, then put the following code in the OnLoad event for the form:

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

Top

Last modified at 06/06/2006 14:51:40