How do I open a form for viewing with empty or blanks fields?

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

Guest

Hi,

I have forms that I would like to open initially with blank fields. The
user would then have the options of looking up a specific record to view,
edit or delete, or the option of adding a new record. This is done with
buttons on the form. There is a combo box to find a specific record.

As it is now, the form opens up and displays the first records in the table.
I don't want it to do that, so how can I get around this?

Thanks so much for your help.
 
On the OnLoad event of the form you can run a line of code that will move the
record to a new record, so it will look like it is an empty form

DoCmd.GoToRecord , , acNewRec
 
Thanks so much! It worked like a charm.

Kathy


Ofer Cohen said:
On the OnLoad event of the form you can run a line of code that will move the
record to a new record, so it will look like it is an empty form

DoCmd.GoToRecord , , acNewRec
Click to expand...
 
Thanks again for your help. That works for all my screens where I need this.
Now maybe you can help me with another question. For a screen that has a
subform, how can I make the subform come up blank as well?

Thanks,
Kathy
 
Boy do I feel stupid. I figured it out. I actually had some bad zero
records in my test tables from long ago messing up my subform. Problems all
solved.

Thanks again!
 
Back
Top