DoCmd.OpenForm

[L.A. Lawyer]

I want to use this command to open a blank (ie, new record) form. The
default opens with all records. How do I make it open a new record?

 

[Jim Allensworth]

I want to use this command to open a blank (ie, new record) form. The
default opens with all records. How do I make it open a new record?

Use acFormAdd in the datamode argument.

DoCmd.OpenForm "frmMyForm",,,,acFormAdd

- Jim

 

[Van T. Dinh]

You can either set the DataEntry Property of the Form to Yes/True or you can
use the DataMode argument of the OpenForm Method like:

DoCmd.OpenForm "YourFormName", , , , acFormAdd