check to see if at the first record

G

Gator

how use code to check to see if the current record is the first record in the
recordset?
 
J

Jeff Boyce

Gator

"First" is relative. How do you sort the recordset to determine the "first"
record? How does Access know to do this?

Regards

Jeff Boyce
Microsoft Office/Access MVP
 
G

Gator

I have a 'previous' button that I want to disable if there are no more
previous records to scroll to...
 
J

Jeff Boyce

No, no, I was being serious. The concepts of "next" and "previous" and
"first" and "last" are all relative. You need to tell Access HOW to know
these things ... or you'll get whatever Access thinks you mean!

Regards

Jeff Boyce
Microsoft Office/Access MVP
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Error: Argument Not Optional 0
how to check previous record 5
Using check box to make record active 3
Cycle to first record? 1
check subform for records 7
OnLoad event criteria 4
open form during recordset update 1
Combo can't find new record in subform 1

Top