Opening Form

[Jeff]

Hi

I have a database where I've specified that a particular form be opened
when the user opens the database. That works fine. Right now, the first
record entered into the system appears on that form when the database
opens.

My question is that the user now wants the form to appear but to be in
"add mode", that is to be at the point where they could add a new
record without selecting the >* key.

Thanks!

Jeff

 

[Guest]

2 way to achieve this depending on your exact needs.

1- simply change your form 'Data Entry' property to YES.

2- in your form's OnOpen Event add the line
DoCmd.GoToRecord acDataForm, "YourFormName", acNewRec

Daniel

 

[Al Campagna]

Jeff,
Use the OnOpen event of the form to GoTo a New Record.

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