MorningSun
Technical User
I am working with Access 2003. I have a form with a subform on it. When a user opens the form it creates a record in a Main table and when they enter information on the subform it creates a corresponding record in a different table linked by AuditNumber which is the primary key in the main table and foreign key in the other table. The user is able to add multiple records to the subform.
Everything works great except at random times, the subform will automatically switch records... for example, they are on Audit 25 and they've entered 3 records on the subform. If they are on the 3rd record in the subform sometimes it jumps back to the 1st record on the subform for no reason.
Has anyone seen this happen? My back end is in a shared network folder and the front end is copied to the user's hard drive. I've verified that 2 users are not in the same record at the same time.
HELP!!
PLEASE RECYCLE AND ENCOURAGE YOUR OFFICE/COWORKERS TO DO SO AS WELL.
Everything works great except at random times, the subform will automatically switch records... for example, they are on Audit 25 and they've entered 3 records on the subform. If they are on the 3rd record in the subform sometimes it jumps back to the 1st record on the subform for no reason.
Has anyone seen this happen? My back end is in a shared network folder and the front end is copied to the user's hard drive. I've verified that 2 users are not in the same record at the same time.
HELP!!
PLEASE RECYCLE AND ENCOURAGE YOUR OFFICE/COWORKERS TO DO SO AS WELL.