How do I make form a data entry form?

A

adarr

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.
 
R

Rick B

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.
 
A

AccessTaxMan

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
 
Top