Every now and again the controls outside of the tab point to a different record to those inside the tab. Moving off the record and back again seems to fix it, but it keeps re-occuring. This happens less than 1% of the time.
Does anyone what's causing this or more importantly, how to fix it.
Here's some background.
It's a split database - an .mdb for the data and a .mde for the front end. All the controls in question are from the same table. The .mdb is 10mb and the .mde is 1.5mb, both sit on a network. The files are compacted daily. User security has been applied. There can be upto 10 users logged on, but only a few will be 'active' at a time.
Does anyone what's causing this or more importantly, how to fix it.
Here's some background.
It's a split database - an .mdb for the data and a .mde for the front end. All the controls in question are from the same table. The .mdb is 10mb and the .mde is 1.5mb, both sit on a network. The files are compacted daily. User security has been applied. There can be upto 10 users logged on, but only a few will be 'active' at a time.