form open

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
 
F

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
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
 
S

Selby

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...
 

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

Setting subform to add mode while main form is in edit mode 9
Access 2003 multiple users entering data 2
Access Click in Table to Open Form 0
null default values on a form 2
Prevent Duplicate Form Entries 0
Data disappearing in bound form 3
Trick filter form combo with DoCmd.OpenForm and Data Entry property 2
Open another form if field checked in one form 1

Top