Blank Data Fields In Form

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

Guest

I am creating a form and I would like to have the data fields to display
"Blank" (nothing in them) when the form is opened for new data entry.
Presently the form displays existing data if the field presently contains
data in the master table. Is this possible? If so how.
 
In the Open form command line, add the command to open the form for data entry
Docmd.OpenForm "FormName",,,,acFormAdd

So the next time you want to open the form for edit, all you need is to
remove the acFormAdd

Docmd.OpenForm "FormName"
 
Back
Top