Hello experts. I have recently migrated an Access back-end database to MySQL. I have an Access form that has a lot of subforms.
Main Form contains Job information
Subform A contains Skids/Rolls - initially opens to show ALL skids/rolls for a job
If main form field 2-up = true - Subform B is then visible - filtered by a field if it contains "B" and Subform A is changed to be filtered by a field if it contains "A".
So the recordsource of these 2 subforms do change when the main form opens after the 2-up field value is determined -- or if the 2-up field is changed.
There are 2 more subforms that summarize data from the Skids/Rolls table but all recordset types are set to snapshot
<b>So here is my problem - no matter what field is updated on the main form, I get: </b> <i> "Another user edited this record and saved the changes before you attempted to save the changes"</i>
I have added timestamp fields to all tables and attempt to force saves to prevent these issues -- nothing I do seems to be helping.
Any/All suggestions will be appreciated.
Thanks a lot!