How do I make form a data entry form?

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

Guest

created a form in access and I would like to see the form display at the
bottom 1 of 28 records. I've tried setting the data entry to NO and it will
show 1 of 28 at that time but when I close the form and re open the form
again, it starts at 1 of 1.
 
What is the record source of this form? If data entry is set to no, and the
record source pulls all the records from the table, then you should see
them.
 
If I understand you correctly, when the form first opens, you want it to be
pointing to the last record (in the table/query that it's based on). If so,
set the forms On Open Event Procedure to the following:

DoCmd.GoToRecord , , acLast
 
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

Sub-Form data entry 9
Form gets stuck in Data Entry mode 6
Opening form unexpectedly closes other form 0
Prevent Duplicate Form Entries 0
Help with form load 5
Trick filter form combo with DoCmd.OpenForm and Data Entry property 2
DMax on existing record to increment serialized # fails 1
data entry form not blank anymore 3

Back
Top