Empty Fields on a form when opening?

  • Thread starter Thread starter Becca
  • Start date Start date
B

Becca

When I click on a command button to launch a form, I want
the form to open with the fields empty, so I can go right
into entering my data. Right now what comes up is the
very first entry I ever made and I made a custom button
that says add new record. I'm stuck! TIA!

Rebecca Ford
 
add this line of code after the OpenForm code, as

DoCmd.RunCommand acCmdRecordsGoToNew

hth
 
Rebecca,

If you always wish to open the form in data entry mode,
change the form's Data Entry property to "Yes".

HTH
Kevin Sprinkel
 
Way too easy! Thanks so much Kevin!
-----Original Message-----
Rebecca,

If you always wish to open the form in data entry mode,
change the form's Data Entry property to "Yes".

HTH
Kevin Sprinkel

.
Click to expand...
 
You must log in or register to reply here.

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

Sorting empty fields 1
open form with empty fields 2
Empty Record on Form Open 2
Empty field when opening Form 2
Access Automatically Send a notification email once a record is added 0
Adding new record to a form 1
Me.Undo doesn't work, records are added each time i enter the form and exit 0
Open another form in Add mode 2

Back
Top