check to see if at the first record

  • Thread starter Thread starter Gator
  • Start date Start date
G

Gator

how use code to check to see if the current record is the first record in the
recordset?
 
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
 
I have a 'previous' button that I want to disable if there are no more
previous records to scroll to...
 
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
Cycle to first record? 1
Using check box to make record active 3
check subform for records 7
open form during recordset update 1
Reference an open recordset in VBA using SQL 1
Combo can't find new record in subform 1

Back
Top