start on new record

[Lapchien]

My form has a control source table with 180k records. I'd like to open my
form and auto have it be ready to have a new record inputted. Is it a before
event?

C

 

[Wayne Morgan]

If you want it to do nothing but new records, you could set Data Entry to Yes in the
form's properties. It is located on the Data tab. If you want the form to be able to edit
records also but just start at a new record when it opens then in the form's OnLoad event
try

DoCmd.GoToRecord acForm, Me.Name, acNewRec

 

[Lapchien]

Thanks, i'll give that a try.

If you want it to do nothing but new records, you could set Data Entry to Yes in the
form's properties. It is located on the Data tab. If you want the form to be able to edit
records also but just start at a new record when it opens then in the form's OnLoad event
try

DoCmd.GoToRecord acForm, Me.Name, acNewRec