Hello all,
I'm using ADO with an Access database using the Jet engine. To the best of my knowledge, when you change a field in the recordset, the field doesn't update in the database until you call the .Update method. The opposite seems to be happening though, when I change a field in the recordset, the field immediately updates in the database instead of waiting until I call the update method.

This is a bit irritating, as it's much easier to change the field in a database and call the update method when the save button is clicked rather than updating all the fields when the save button is clicked. It's also easier to validate: simply check if the recordset is in the edit status and if so, update it.

Does anyone know why that problem is happening? I find that it's only happening on one of my forms, so I must be doing something right somewhere, but I can't seem to find the difference between the forms that wait until Update is called to update the recordset and those that don't.