EOF & BOF

[Ben James]

Hi people, I am creating some forms using Access XP and
have created my own user navigation buttons which are
Last, Previous,Next and Last. If the user clicks on say
the last button and then clicks on the next button,
he/she is already at the end of the database and I want
to be able to have a popup box appear to tell the user
there are no more records. And the same with the First
and previous buttons.

I am very familiar with VB and in VB it would look
something like:

if data1.recordset.eof then


Thanks a lot