Form opens on a new record

  • Thread starter Thread starter Mark Weaver
  • Start date Start date
M

Mark Weaver

When I open my MS Access form I would like to open on a
new record, not the 1st record.
 
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.
 
When you view the form in design mode, right click to get the form
properties. Under the Data tab, set Data Entry to Yes.
 
Back
Top