How to go to last record in a continuous form (Access 2000)

Topic

New Reply

I have a button on a form that opens my frmNewFees form. When it opens it shows a continuous form of all the fees that are already entered. Is there any way to get it to go to the last record or a new record when the form opens? That way my users don’t have to scroll down a long list of fees before they can enter a new fee.

Reply | Quote

Replies

In the on load event of the form use :
Private Sub Form_Load()
DoCmd.GoToRecord acDataForm, Me.Name, acLast
End Sub

Reply | Quote

Sorry, I’ve read the post not completely.
For a new record use in the on load event of the form:
Private Sub Form_Load()
DoCmd.GoToRecord acDataForm, Me.Name, acNewRec
End Sub

Reply | Quote

Thanks, Francois. It works great.

Reply | Quote

Thanks, Francois. It works great.

Reply | Quote

In the DoCmd statement “Me.Name” is a refference to what?

Reply | Quote

In the code behind a form, Me refers to the instance of the form that is running the code. So instead of referring to Forms!frmNewFees, you can refer to Me. Much shorter and easier. In the instruction Francois posted, Me.Name is the name of the form. He could have used “frmNewFees”, but that would cause an error if you decide to rename the form, while Me.Name stays valid.

Similarly, in the code behind a report, Me refers to the instance of the report that is running the code.

Reply | Quote

In the code behind a form, Me refers to the instance of the form that is running the code. So instead of referring to Forms!frmNewFees, you can refer to Me. Much shorter and easier. In the instruction Francois posted, Me.Name is the name of the form. He could have used “frmNewFees”, but that would cause an error if you decide to rename the form, while Me.Name stays valid.

Similarly, in the code behind a report, Me refers to the instance of the report that is running the code.

Reply | Quote

In the DoCmd statement “Me.Name” is a refference to what?

Reply | Quote

Sorry, I’ve read the post not completely.
For a new record use in the on load event of the form:
Private Sub Form_Load()
DoCmd.GoToRecord acDataForm, Me.Name, acNewRec
End Sub

Reply | Quote