start on new record

  • Thread starter Thread starter Lapchien
  • Start date Start date
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
 
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
 
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...
 
Back
Top