Help with Subform and GoToLast command

[Daryl Austin]

Hi,

I have a form using tab controls. The 2nd tab control is named "weekly_details " in which I embedded a form called Frm:weeklydetai ls. What I want to happen is when I click on that tab control, the recordset shown is the last record in my table called "weeklydetails" . My logic below doesn't seem to work very well. Any suggestions?

Private Sub Weekly_Details_Click()
    'sets focus to the Subform Form_frm:weeklydetails
    Me.Form_frm: weeklydetails.SetFocus
    'move to the last record of the weekly details database
    DoCmd.RunCommand (acCmdRecordsGoToLast)
End Sub

Thanks.

Daryl

[Stewart Ross]

In my view a far simpler solution is to base your subform on a query, and within that query sort the data in reverse order on whatever key field or combination of fields determines the 'last record' you refer to. Access will always then show you the 'last record' when the form is opened.

-Stewart

[neelsfer]

I use something like this to move to the last record in subform

DoCmd.GoToControl ("subformname")
DoCmd.GoToRecord , "", acLast