The problem comes up when I edit and save a record on tab 1, then go to tab 2 to to edit a different field of the same record. I get the following error message:
The data has been changed
Another user has edited this record and saved the changes before you attempted to save your changes. Re-Edit the record.If you click OK in the dialog box, Access will let you edit the record.
The problem does not occur when the tables are in Access rather than SQL.
Any ideas?
Thanks,
Dante