I recently coded a simple field change as evidence of a transfer from Active to History or back to Active from History in a Patient table, where there is only one record for each patient.
Each (Active or History) combo box displays the transferred record properly but, if even a single-user attempts to select the transferred record from the newly-displayed item in the receiving combo box, the following Microsoft Access message appears: "The data has been changed" "Another User edited this record and saved the changes before you attempted to save the changes" "Re-edit the record"
If one closes the combo box, then reopens it, the record can be selected. Although this might be handled with a requery of the form, I would rather not because I would like to keep looking a the transferred patient's data on the form after the transfer.
A requery of just the receiving combo box right after update of the record does not eliminate the message.
This is not an error message and thus cannot be trapped. It seems like something being temporarily hung on to by editing and updating of the record.
Any suggestions?
Thank you.