Records

[John]

I have a form called form1 say, that has a button that takes the user
to another form say form2. On form2 there are now hundreads of records
in a single form view.

Ok the problem is that I want the user when they click on the button
in form1 to go to the last record instead of the first record.

The user could then see the last process or record they worked on.

[salad]

Re: Records

John wrote:

I have a form called form1 say, that has a button that takes the user
to another form say form2. On form2 there are now hundreads of records
in a single form view.
>
Ok the problem is that I want the user when they click on the button
in form1 to go to the last record instead of the first record.
>
The user could then see the last process or record they worked on.
>

Private Sub Form_Open(Cance l As Integer)
DoCmd.GoToRecor d acDataForm, Me.name, acLast
End Sub