Loading Form

  • Thread starter Thread starter Shiner452
  • Start date Start date
S

Shiner452

Whenever I open a form it opens on the first record. I want the form t
always open to start a new record so i have less risk in my user
changing data. Is there any way i can set the form to load so that i
is set to start a new record
 
Shiner,

If you don't want to allow the user to scroll back to existing previous
records, you can set the Data Entry property of the form to Yes. If you
still want to allow access to previous records, you can move to a new
record on the form via the macro or vba procedure which you use to open
the form. In VBA...
DoCmd.GoToRecord , , acNewRec
 
what code are you using to open the form?
the docmd.openform procedure has a DataMode property that can be set t
acFormAdd. This will cause the form to be opened to a new record
 
Yes, of course you can set it to start a new record each time a user to open
the form.

Here is you need to do, add "DoCmd.GoToRecord , , acNewRec" at the Open
Event on the form.

HTH,
Rudy
 
Back
Top