Open Form ready for new record

[caspermurphy]

Hi,

My question is in regards to a question that was answered in the following link:
http://www.mrexcel.com/board2/viewtopic.php?t=103825&highlight=opening+form+record


I would like to do this but I am so new at access I do not know exactly where I would put docmd.goto acNewRec.

I apologize for what I am sure is a no brainer.

Thank you in advance for any help.

John

 

[mdmilner]

bat17's suggested putting it in the _Open event for the form.
What this means is this:

Create your form - base it on a table or query using the wizard interface.
Save it
Re-open in design mode. Right click the blue bar at the top of the form and select properties
Go to the Event Tab
Under the entry for On Open click in the field
A little select down arror and a button with ... in it will appear.
Hit the down arrow and select [Event Procedure]
Then, hit the three dots (button)

This takes you into the code module for the form (just now created)

Add that line

Mike

 

[caspermurphy]

mdmilner, thank you very much. That little lesson did the trick. ray: