Open a form at a new record

  • Thread starter Thread starter gavin
  • Start date Start date
G

gavin

I seem to recall this was asked fairly recently but I can't find the post.
How do I open a form with a new (blank) record. I know if I set the form's
Data Entry property to Yes I get a new record but in this case I can't see
the other records already entered into my table. Can anyone tell me how to
do this?


Regards,


Gavin
 
Put the following code in the Open event of the form:
DoCmd.GoToRecord,,acNewRec
 
Just what I need - many thanks! Can I just ask what the ",," does?


Regards,



Gavin
 
Look at the GoToRecord Method n the Help file. The commas are placeholders
for optional parameters.

Steve
PC Datasheet
 
If you ever need outside help on any projects, be sure to keep me in mind.

Steve
 
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

acnewrec? 1
Access Automatically Send a notification email once a record is added 0
OPen form to new record 5
Generating a new Record 14
new record and form 4
Adding new records via recordset 4
Pop-up form that creates record that links 1:1 to main form 0
Form record navigation behaviour 4

Back
Top