This is a (rather long-winded) question about "updating" a Form -- which is based on a query -- from a second Form which has altered some of the data of the Table from which the Query is sourced.

A typical table may contain many fields populated with LONG INTEGERS which are the foreign keys accumulated from data collection Form(s) utilizing ComboBox  controls. This creates an efficient storage paradigm but is unsuitable for human interpretation.  Of course, a query relating the various ancillary data tables is used as Source for any "displaying" Forms.

However, it's often needed to edit an item or two. This cannot be done in the query, but in its underlying source table which is then reflected by the query. That's fine. I can open a Form with the original Table as its data source where ComboBoxes can easily be used to supply the foreign key data. I rely on an "updating" of the other Form -- the "display Form" from the "edit Form" -- to show the edit results. I'd like results to display immediately after changes are made in any control effecting the original Table.

So. . .what's the recommended method to execute an "update" from the one Form to the other. Currently, when more than one field value happened to have been changed and I'm "updating" more than once, Access throws a warning message about edits already having been made "by another user". If I close this "edit" Form and reopen it after each change, I am then able to make a subsequent alteration. How is this done without closing/re-opening the form?