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"
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Access Form - Lock Fields from Editing 0
Trick filter form combo with DoCmd.OpenForm and Data Entry property 2
Start out with blank fields in listboxes 4
Prevent Duplicate Form Entries 0
User Sets Control Default Value 1
Access Access Report Works on One Machine but not Another 3
Adding new record to a form 1
Check for duplicate with multiple criteria 4

Back
Top