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.
Click to expand...

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.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Separate Form 0
Going to first record 0
In MS Access I want form to be open for fresh record entry 2
Startup Form on New Record 9
Open to Blank 7
Access Command to run access, open to specific form and specific record 1
Access Automatically Send a notification email once a record is added 0
Combo box - 1st record selection 1

Back
Top