How do you get the form to automatically go to a new record?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi

I need the main form when opening to go to a blank/record, but I do want to
be able to click back (through the record selector) and view all the records
on file. I know you can set it to Data Entry but this locks all the existing
records and makes them non visible when this option is picked.

I know this should be straight forward but can't find any info on it.

Any advise would be great.

Thanks

Stu
 
Stu,

DoCmd.GoToRecord acDataForm, "YourForm", acNewRec

after opening the form.

Sprinks
 
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

Going to first record 0
First Subform record gets modified when closing form 3
Set Focus to Record Selector? 1
Highlight selected record on continuous form 1
Separate Form 0
Access Automatically Send a notification email once a record is added 0
Main form with two sub forms 1
Record selector on a sub-form 3

Back
Top