[Okta Webinar] Learn how to a build a cloud-first strategyRegister Now


How do I update a table without closing a form?

Posted on 2010-01-05
Medium Priority
Last Modified: 2013-12-20
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:
"Write Conflict
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?

Question by:DaveRoehrman
LVL 120

Accepted Solution

Rey Obrero (Capricorn1) earned 2000 total points
ID: 26183891
before opening the recordset, place this line


Author Closing Comment

ID: 31673137
Just what the doctor ordered!  Many thanks.

Featured Post

Keep up with what's happening at Experts Exchange!

Sign up to receive Decoded, a new monthly digest with product updates, feature release info, continuing education opportunities, and more.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

This article shows how to get a list of available printers for display in a drop-down list, and then to use the selected printer to print an Access report or a Word document filled with Access data, using different syntax as needed for working with …
Instead of error trapping or hard-coding for non-updateable fields when using QODBC, let VBA automatically disable them when forms open. This way, users can view but not change the data. Part 1 explained how to use schema tables to do this. Part 2 h…
What’s inside an Access Desktop Database. Will look at the basic interface, Navigation Pane (Database Container), Tables, Queries, Forms, Report, Macro’s, and VBA code.
Add bar graphs to Access queries using Unicode block characters. Graphs appear on every record in the color you want. Give life to numbers. Hopes this gives you ideas on visualizing your data in new ways ~ Create a calculated field in a query: …
Suggested Courses

868 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question