Open form with new record

J

Josh W

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
 
V

Van T. Dinh

Use the options in the OpenForm Method.

DoCmd.OpenForm "FormName", , , , acFormAdd

HTH
Van T. Dinh
MVP (Access)
 
Top