Record count

[Rich]

I can't figure out how to return the number of record left after moving to a selected record, ie. if I'm on record 5 of say ten how to get there are 5 records remaining.
Many thanks.

 

[joeyreyma]

if you are operating on a recordset, then use the AbsolutePosition property. however, counting starts from 0 up to 1 less the number of records (same as RecordCount - 1) in your recordset basing on the ordinal position of the record. thus, you can deduct the (absoluteposition + 1) from recordcount to return the number of records left.

 

[Rich]

Thanks Joe