find end of table before the issue of gotorecord command

[paulevans]

Hi all

I have a continous sub form and there are 4 fields however only one can be changed. I therefore would like to be able to go from record to record.

I have used:

docmd.gotorecord ,, acnext

however this causes a problem when I reach the end of the table.

How can I find out if there are no more records in my table.

thanks for any help

Paul

 

[Mile-O]

You will need to use a DAO Recordset Clone to look at the next record in the table and determine if it's the end of the recordset. I know I have posted something along these lines before and you'll no doubt find it by using recClone as a search term.