Open form with new record

[Guest]

Is there a way to open a form with just a new record showing, ready to input data?
I know about DoCmd.GoToRecord,,acNewRec
Is there another way that doesn't pull thousands of records?
Thanks so much!!
Josh W

 

[Larry R Harrison Jr]

Try something like

DoCmd.OpenForm "nameof_form_here", acNormal, "", "", acAdd, acNormal

LRH
http://www.dbases.net/knowledge_base/index.html

 

[Van T. Dinh]

Use the options in the OpenForm Method.

DoCmd.OpenForm "FormName", , , , acFormAdd

HTH
Van T. Dinh
MVP (Access)

 

[Guest]

Thanks, Van and Larry!
Josh