start on new record

L

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
 
W

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
 
L

Lapchien

Thanks, i'll give that a try.


Wayne Morgan said:
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
Click to expand...
 
Top