G
Guest
I have an app that runs unattended with this on the form timer:
DoCmd.GoToRecord acDataForm, Me.Name, acFirst
'Do stuff here
Do While ?? (this is the question - do while not on last record)
DoCmd.GoToRecord acDataForm, Me.Name, acNext
Loop
Now, I know how to use a recordset and "Not EOF" to find out when I am at
the end of a recordset. How can I determine if I am on the last record when
simply running through the records on the form, though? (yes, I know that I
could just look for a null required field or something like that, but I'm
trying to simply prevent navigation past the last record.)
This is probably way too simple, but I'm missing the answer somewhere.
DoCmd.GoToRecord acDataForm, Me.Name, acFirst
'Do stuff here
Do While ?? (this is the question - do while not on last record)
DoCmd.GoToRecord acDataForm, Me.Name, acNext
Loop
Now, I know how to use a recordset and "Not EOF" to find out when I am at
the end of a recordset. How can I determine if I am on the last record when
simply running through the records on the form, though? (yes, I know that I
could just look for a null required field or something like that, but I'm
trying to simply prevent navigation past the last record.)
This is probably way too simple, but I'm missing the answer somewhere.