Loading Form

[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

 

[Steve Schapel]

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

 

[yakule]

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