check for 1st or last record (1 Viewer)

DewMan

Registered User.
Local time
Today, 04:59
Joined
May 16, 2003
Messages
15
I can set up a counter to check for the first and last record but there must be a simpler way if I can get the syntax right.
something like;
If Me.current record.aclast = TRUE then...
 

Mile-O

Back once again...
Local time
Today, 04:59
Joined
Dec 10, 2002
Messages
11,316
Code:
If Me.EOF Then   ' last record

and

Code:
If Me.BOF Then   ' first record
 

DewMan

Registered User.
Local time
Today, 04:59
Joined
May 16, 2003
Messages
15
Once again brighter minds have shone through.....Thanks a lot!!!
 

Users who are viewing this thread

Top Bottom