You will probably want to look up the record within each object that will use it. Relational databases can retrieve a record really fast if you can make the parameters simple. If each record has a unique ID, the "WHERE ID = ...." is a really quicjk lookup.
The bookmark is valid only for the recordset in which it is contained--it is a pseudo-column. When a recordset is opened, each record in the recordset is assigned a unique bookmark. You can use that bookmark to quickly find a record in the recordset to which it belongs, but it is not part of the actual data.
You can make a globally dimmensioned recordset, which will then be available to any object in the global scope, and prehaps that, too, will work for you.
You can declare it globally, and open it within a certain form or procedure. Once open, any form, procedure or object can then access it. This is usually not the best approach; it quickly gets involved to keep track of the global recordset's status.
|