Checking for the end of thetable

[haneen97]

Hi,

I am trying to display a message for the form user when he/she hits the "Next" button at the last record of the table. The auto message from the access form does not come up until the user hits "Next" one more time after the last record.

Can you tell me what property should I check for to inform the user that they are at the last record already?

Thanks
Mo

 

[SQLBI]

Mo,

You need to check for EOF (End of File) at the point the button is clicked.

Access help should help you with the coding.

Leigh Moore
LJM Analysis Ltd

http://www.ljm-analysis.co.uk