Is it possible to assign the first record of a recordset to another recordset using either ADO or DAO? If so, how? For example, I've opened a recordset of all available "open" codes we use, sorted the set ascending, and moved to the first record. I've done this to access the next numeric code to use. I didn't want to lock out other users, so I thought to assign the single record and close the original recordset to free up those codes. However, when you open a recordset and have just a single record displayed at a time(like in a form), are those records available for updating/changing for other users accessing the database or are they locked by the current user? I hope I made sense.