Updating bound controls in code
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.