Failure to Save new data in first record
Posted on 2004-04-22
My VB application uses a data control to connect to an Access table.... I use a combo box to navigate between the table's records without a problem.
When I change the data in the textboxes which are bound to a record in the table the new data gets saved and replaces the old data as soon as I move the recordset by selecting another recrord from the combo box... the only exception to this is the top record in the combo box...... when new data is entered in that first record and I move to a different record I find the textboxes revert back to their origninal value, refusing to update the changes.... every other record upadate the changes but not the first recrod.
Here is the combo box click event code:
Do Until Combo1.Text = Me.Text1.Text
If Not rs.EOF Then rs.MoveNext
I noticed the following: When data is changed in the top record and I select another record from the combo box, the combo box doesn't respond the first time.... it doesn't move the recordset until I click a second time.... please help if you can.