form open

  • Thread starter Thread starter Selby
  • Start date Start date
S

Selby

I have created a form that has its first field as a look-up, but when I open
it to begin entering data, it automatically shows the first entry in the
search table it references. How can I have the form open up with no data
already in the fields? Thanks!

Access 2003
 
I have created a form that has its first field as a look-up, but when I open
it to begin entering data, it automatically shows the first entry in the
search table it references. How can I have the form open up with no data
already in the fields? Thanks!

Access 2003
Click to expand...

Do you mean you always wish to open the form to a New Record?

DoCmd.OpenForm "FormName" , , , , acFormAdd

or simply set the form's DataEntry property to Yes
 
Thank you so much - that did it!!!

fredg said:
Do you mean you always wish to open the form to a New Record?

DoCmd.OpenForm "FormName" , , , , acFormAdd

or simply set the form's DataEntry property to Yes

--
Fred
Please respond only to this newsgroup.
I do not reply to personal e-mail
.
Click to expand...
 
Back
Top