Want to open a form and it be ready for a new record

G

Guest

When I havea command button open a form, it opens with the first record on
there, to stop users going into that record accidentally and editting it, i
want it to open with a blank form ready for a new input, is this possible
please
 
G

Guest

from Rainbow01 Hong Kong

DoCmd.OpenForm "YourFormName", , , , acFormAdd

"Matt, Sheffield, UK" 來函：
 
R

Rick B

Please note, this is asked and answered all the time. In the future, I'd
suggest you search for your answers before posting a new thread. The
easiest way I have found is to go to www.google.com, click the "groups"
option, and enter a search string similar to the following...

microsoft.public.access default to new record
 

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

To ready for new record next time form is opened 4
Going to first record 0
if form open criteria is blank, I do not want a new record to open 1
Adding new record to a form 1
Access Automatically Send a notification email once a record is added 0
Trick filter form combo with DoCmd.OpenForm and Data Entry property 2
Cannot Add new record, then disable AllowAdditions 2
Having a blank, new record for entry when you open a form 7

Top