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

[Stu]

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

 

[Sprinks]

Stu,

DoCmd.GoToRecord acDataForm, "YourForm", acNewRec

after opening the form.

Sprinks

 

[Van T. Dinh]

Check Access VB Help on the GoToRecord method.