New records

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

Guest

Hello. :
1) When I open a form, I'd like to jump automatically to a new record. How is this done please
2) What terms would I use in Google to find the answer to this? I tried but I don't know enough yet to even ask good questions
3) Where is the answer to this in Access Help

Thanks
Ric
 
Anything you can do from the menu at the top of the screen can be coded from
DoCmd.RunCommand .....

For example, to go to a new record use:
DoCmd.RunCommand acNewRec

To do it when a form opens, put the code in the OnOpen event of the form.

Look at DoCmd and RunCommand in VBA Help.

--
PC Datasheet
Your Resource For Help With Access, Excel And Word Applications
(e-mail address removed)
www.pcdatasheet.com



Rick said:
Hello. :)
1) When I open a form, I'd like to jump automatically to a new record. How is this done please?
2) What terms would I use in Google to find the answer to this? I tried but
Click to expand...
I don't know enough yet to even ask good questions.
 
Your answer gave me enough info to Google the exact syntax: DoCmd.GoToRecord , , acNewRec

Attached to the On Open event, it's working. Thanks.
 
Back
Top