Starting on a new record in an input form

[ScottSisk]

Right now, when I open my input form, it brings up the first record in the table. How do I set up the form to automatically start a new record when opening the form?

 

[pdx_man]

In the Form's On Load Event Property (using an event procedure) use this code:


DoCmd.GoToRecord , , acNewRec

HTH

 

[ScottSisk]

Thanks, that worked perfectly!