Records

[Eric]

Dear all,

I've made a form and all went well.

I would like to see the last record that entered everytime when user open
the form. How can i do that

Eric

 

[Allen Browne]

I would like to see the last record that entered everytime when user open
the form. How can i do that

1. Set the form's On Load property to:
[Event Procedure]

2. Click the Build button (...) beside the property.
Access opens the code window.

3. Set up the code like this:

Private Sub Form_Load()
If Not Me.NewRecord Then
RunCommand acCmdRecordsGoToLast
End If
End Sub