I know that when you move through a form's recordset, Access does an implicit commit on every move if the data has changed, but behind the scenes, editing a value in a textbox, say, causes a recordset.Edit

What is the datasource for the form? Does it include all of the columns of the table, or is it based on a Query?

Typically, a recordset will not be updatable unless you have selected the primary key on the table. If the table doesn't have a primary key, or if you have excluded it from the select statement then the recordset may not be updatable.

Also, querys that join two tables together may not be updatable, because Access has trouble figuring out which table to update.

I assume this code is part of a Form in Access? Or is this in VB?

The logic inside of your Do loop doesn't make much sense to me either, as you'll be overlaying the value in Me.Customer_Lookup every time with the same value, whatever is in Me.CName... and, that field isn't part of the recordset, so, you're not using any fields from the recordset at all.

If all you want to do is update your database, you can create a query and set it as an Update query, then just run the query and it will update your database without you having to code anything (just point and click in the Query builder).

As I said above, a recordset might not be updatable, if it includes a JOIN between two tables. You might make it updatable, if you include the primary keys of both tables in the list of columns selected, even if you never display them on your form, but sometimes it works, sometimes it doesn't.

I know that when you move through a form's recordset, Access does an implicit commit on every move if the data has changed, but behind the scenes, editing a value in a textbox, say, causes a recordset.Edit statement, and the move causes a Recordset.Update statement.

When updating the recordset in the loop, do you think he'd need to explicitly issue the Edit and Updates?

This article is a continuation or rather an extension from Cascading Combos (http://www.experts-exchange.com/A_5949.html) and builds on examples developed in detail there. It should be understandable alone, but I recommend reading the previous artic…

In Debugging – Part 1, you learned the basics of the debugging process. You learned how to avoid bugs, as well as how to utilize the Immediate window in the debugging process. This article takes things to the next level by showing you how you can us…

Familiarize people with the process of retrieving data from SQL Server using an Access pass-thru query. Microsoft Access is a very powerful client/server development tool. One of the ways that you can retrieve data from a SQL Server is by using a pa…

With Microsoft Access, learn how to start a database in different ways and produce different start-up actions allowing you to use a single database to perform multiple tasks.
Specify a start-up form through options:
Specify an Autoexec macro:
Us…