Updating bound controls in code

[Bob Clemens]

When I have controls bound to a disconnected ADO 2.6 recordset, and I update
the controls (Textboxes primarily) in code, I find that if I reconnect the
recordset to a connection, and call rs.UpdateBatch, without first moving
off the current record, the changes are not applied to the database.

To solve this, I must call rs.Move 0 before calling rs.UpdateBatch. I find
that calling rs.Update does not solve it.

This behaviour is with a Jet database and the Jet OLEDB provider.

Has anyone else had experience with this?

-- Bob C.