Detecting and acting on End of Table

[JHB]

Hi:

I have an Access macro that moves down one record through a table when
the user presses enter.

My problem is that when the last record in the table is reached, and
the user presses enter, the macro tries to move to another record and
the result is an error condition. I would like some guidance in how to
dectect that one is in the last record of a table (or that the table
has no more records). Preferably using Access Macro language (which is
what I have used) but any way to do it within program control would
be appreciated.

Thanks in advance

John Baker

 

[JHB]

I should have indicated that I am using Access 2000, which may have
some influence on your response.