Form data entering

  • Thread starter Thread starter Leon
  • Start date Start date
L

Leon

When I open up the form to enter data it shows record 1.I must then select
the >* to add a new record. Some times I forget to do this and start
entering data into the first record before I realize what I am doing. How do
I get the form to automatically bring up the next blank record in order to
enter data? TIA
 
Leon,

One way is to set the Data Entry property of the form to Yes. However,
this will mean you can't scroll back to see previous records, which you
may or may not want. If you do want to be able to access previous
records, do it like this instead... add a line of code to the routine
that you use to open the form, like this:
DoCmd.GoToRecord , , acNewRec
 

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

DMax on existing record to increment serialized # fails 1
Macro doesn't work first time form is opened. 2
MS Access - Forms 1
On click add record 1
Access 2003 multiple users entering data 2
Adding new record to a form 1
Save data entered into a form 5
Copy Data from Subform 4

Back
Top