Updating records in ms access
Recordsets are objects that represent collections (sets) of records.
A small screencast will be included to show where to click to effortlessly get the code inserted.
The code below opens a recordset taken from a table in the current database on a query or attached table Access defaults the Type property to db Open Dynaset.
Many Thanks Bill, Welcome to the Lounge as a new poster.
Yes, if you use a different name each time you will have to change the file name in the update query.
HTH BTW: It is proper Lounge etiquette to start a new thread with a new question and not add on to an existing one.