Form opens on a new record

[Mark Weaver]

When I open my MS Access form I would like to open on a
new record, not the 1st record.

 

[Bruce M. Thompson]

When I open my MS Access form I would like to open on a

new record, not the 1st record.

An alternative to Dave's solution might be to simply move to a new record when
opening the form. You can insert the following line into the form's "On Open"
event procedure:

DoCmd.GotoRecord , , acNewRec

This will open your form to a "new" record, yet allow the user to see existing
records, too.

 

[Dave]

When you view the form in design mode, right click to get the form
properties. Under the Data tab, set Data Entry to Yes.