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?

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


DoCmd.GoToRecord , , acNewRec

HTH

Thanks, that worked perfectly!