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
 
Back
Top