New Record when form loads

[CodeCruncher]

How do i set a form to start on a new record when it loads? I have tried the data tab in properties but there isn’t anything there what do I do? Can I use some VBA code?

 

[grnzbra]

In the OnOpen event:

DoCmd.GoToRecord , , acNewRec

 

[ejstefl]

Or you can set the form's data entry property to yes. This will only allow you to add new records to the form.