I'd appreciate any direction with the following. I have an Access database and am developing a VB6 interface for adding / editing data. I've followed most of the chapters in John Connell's book "Beginning VB6 Database Programming" and have a functional user interface. I want to limit users' navigation (and adding/deleting records) in the recordset to the initial form/window, and then pass the location of a specific record through the remainder of the program. I can't find anything in the book which explains how to lock into that specific record. My subsequent forms are all set up, but I obviously don't want the user to have to re-find a specific record with each form. I see something about using a "bookmark" but I don't know if that's the way to go. As you can tell, I'm a novice programmer, and not quitting my day job anytime soon. Any direction with this is much appreciated. Thank you in advance.

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.