We are experiencing an odd phenomenon. We have an access database. The data (backend) resides on the server. All users for the database have a front-end that is linked to the tables on their local hard drives. I've created forms for them to use for data entry and navigation to the different parts. Lately we've been experiencing a situation where someone is adding data to an existing record. (This data is displayed on a form.) When the data is changed (e.g., a date changed, a number changed, text field changed) and they move to another field on the form, the record switches to a different record entirely! It doesn't appear to matter if they use the tab key, enter key or mouse to move to a new field. I've compacted the database.
If I go directly to the tables, I can modify data without a problem. I do not have users who are familiar enough with access that they can use this database with the forms. We've had this database for several years and it has only recently (last few months) started this strange behavior. I am at a total loss as to why.