ClaraBarton
Registered User.
- Local time
- Today, 15:52
- Joined
- Oct 14, 2019
- Messages
- 661
I found this from Arnelgp:
If I put it in the OnLoad event, it works well. But I'd like to have my register always look this way.
If I put it in the Current event... Just mess. Each line calls the current event again and I end up with a stack overflow.
How would I fix this?
Code:
Sub ShowLastRows()
With Me.Recordset 'use the recordset in the form, not the clone[/COLOR]
.MoveLast 'move to the last record, shows at top of list[/COLOR]
.Move -19 'move up 19, shows more records, last row moves down[/COLOR]
.MoveLast 'move last again, highligh moves to bottom[/COLOR]
End With
End Sub
If I put it in the Current event... Just mess. Each line calls the current event again and I end up with a stack overflow.
How would I fix this?