Goto record number

[Jan]

I am working with a non-bookmarkable record set. Is it
possible to get the position of the current record by,
using rcd.AbsolutePosition to obtain the a reference.
Search for another record based on criteria from the
current record move to that record. then use the first
records AbsolutePosition to move back to the first record?
Thanks for any help. Jan

 

[Ken Snell [MVP]]

Does the recordset contain a primary key? If yes, use the value of that
primary key to "store" the record's "location" and to find it later on.

AbsolutePosition might work, but if the recordset can be modified by other
users while you're using it, records might be in different locations.

 

[Guest]

I have had an primary key field added to my table. All is
now fine.
Many Thanks Jan