form open

[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

 

[fredg]

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

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

 

[Selby]

Thank you so much - that did it!!!

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
.