How do I update a table without closing a form?
Posted on 2010-01-05
The following sequence of events takes place:
1 - I open fm_Example open, with controls bound to tbTable
2 - I make changes to bound controls on the form
3 - While the form is still open, I open rs_Records also from the tbTable that the form is bound to
4 - I make changes, .update, and .close rs_Records
5 - I close fm_Example
I get this message with the indicated options:
This record has been changed by another user since you started editing it. If you save the record, you will overwrite the changes the other user made.
Copying the changes to the clipboard will let you look at the values the other user entered, and then paste your changes back in if you decide to make changes." with the following option buttons:
Save Record Copy to Clipboard Drop Changes
The changes I made on the form must be conflicting with the changes in the recordset.
I assume I need to update the table from the form before opening the recordset,
How do I UPDATE THE TABLE FROM THE FORM while it's still open without moving off the current record?