Make last record in Form's RecordSource the current record

[GraeagleBill]

Make last record in a Form's Sub-form RecordSource the current record when the sub-form displays. I put the following code in the OnLoad event and the "MoveLast" statement referring to the clone works but that doesn't effect the current RecordSource. If there is a option in Access to accomplish what I've asked it would seem that my Google search expression missed the mark?

    Dim rst As Recordset

    Set rst = Me.RecordsetClone
    rst.MoveLast

[ranman256]

what about :
Me.Recordset.MoveLast

(filter off)

[GraeagleBill]

While I didn't mention in my original post about my attempt to use exactly what you've suggested to begin with, the RecordSource is Filtered so maybe that's why the Me.Recordset.MoveLast failed?

[pbaldy]

What about GoToRecord with acLast?

[ArviLaanemets]

While I didn't mention in my original post about my attempt to use exactly what you've suggested to begin with, the RecordSource is Filtered so maybe that's why the Me.Recordset.MoveLast failed?

The RecordSource is probably somehow ordered too? Set this order DESC, then the currently last record will be 1st.

[GraeagleBill]

Thanks Paul, that did the trick!
Bill

Private Sub Form_Load()
Me.Filter = "SerialNo <= " & intBlkSz
Me.FilterOn = True
Me.FilterOnLoad = True

DoCmd.GoToRecord , , acLast
End Sub

[pbaldy]

Happy to help Bill!