B
Bob
Is there a way to force the last record to always display
when opening the Form?
when opening the Form?
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
V
Van T. Dinh
In the Open Event of the Form, you can use the GoToRecord Method to make the
last Record the Current Record on your Form.
Check Access VB Help on the GoToRecord Method.
last Record the Current Record on your Form.
Check Access VB Help on the GoToRecord Method.
S
Sandra Daigle
Try the following on your form's open event. The If test prevents a runtime
error when there are no records in the form. Also, this assumes that the
form's recordset is already sorted accordingly.
Private Sub Form_Open(Cancel As Integer)
If Not (Me.Recordset.EOF And Me.Recordset.BOF) Then
Me.Recordset.MoveLast
End If
End Sub
error when there are no records in the form. Also, this assumes that the
form's recordset is already sorted accordingly.
Private Sub Form_Open(Cancel As Integer)
If Not (Me.Recordset.EOF And Me.Recordset.BOF) Then
Me.Recordset.MoveLast
End If
End Sub
K
Kelvin
The suggestions from the others will work but remember that the last record
will be based on the sorting option you have for your table or query.
Either suggestion will move to the last item in the list. If you're trying
to move to the last entry added, you'll need to do more.
Kelvin
will be based on the sorting option you have for your table or query.
Either suggestion will move to the last item in the list. If you're trying
to move to the last entry added, you'll need to do more.
Kelvin