EOF & BOF

  • Thread starter Thread starter Ben James
  • Start date Start date
B

Ben James

Hi people I am creating forms to access 2 tables in my
database using Access XP.

I have created my own nav buttons - First, Previous, Next
and Last. If the user clicks on the last button he/she is
already at the end of records so if they press the next
button after this, I want a message box to pop up telling
the user there are no more records. I am familiar with VB
and it would look something like this:

if data1.recordset.eof then
msgbox "You are already at the end of the
records!!"

How can i do the same sort of thing in Access XP??

Thanks in advance
 
Use the Button Wizard in the Toolbox. It will give you a
message that "You can't go to the specified record." If
you don't like that message, trap it and change it.
Gordon
 
Back
Top