Right now I'm looping through the recordset and updating the information from the main table (just so I know it works and can finish up other things). Once the changes are made, the user will click on a button and the changes will be committed to the main table. If i have the recordset, how do I make the Update statement to reflect the changes from the (disconnected) recordset? I don't want to go through the trouble of trying to fix the insufficient key column error.

Thanks again
Mark