automatically go to new record

[QuietRiot]

nevermind solved!!

[icthus123]

i have a userform it starts on 1st record.

how do i make it so when you open the form it automatically brings up a new record to be entered and not record 1.

This should work.


Private Sub Form_Open(Cancel As Integer)
DoCmd.GoToRecord , , acNewRec
End Sub

[icthus123]

Or if you're opening the form from a switchboard you could use:


DoCmd.OpenForm frmName, , , , acFormAdd