cricketbird
Registered User.
- Local time
- Today, 05:32
- Joined
- Jun 17, 2013
- Messages
- 108
I have a Single Form (Products) with a subform (Components). This has been working fine for 7+ years. However, a few weeks ago, a user said they updated the components for product A, then switched to product B and the subform continued to show the components from product A. Nobody else was having the issue and neither I nor the user could reproduce it, so I dismissed it as a fluke. Yesterday, a different user said they had looked at product C, then switched to product D, entered a lot of component data for D and it looked correct, but when they closed and reopened the form, D's components were now listed on product C. Today, two more users (out of 20 active users) said they experienced this, but only intermittently and that mostly it has been working fine.
I've checked that the master/child links are working (and clearly they nearly always are). Is this a sign of corruption of some sort? Or a common problem with a known cause? Tearing my hair out over this one...
The data is in an .accdb backend on a shared network drive, while each user has their own .accde front end installed locally. We are running Office 365. Users navigate between records on the mainform by typing the product ID into a text field (After Update:
).
I've checked that the master/child links are working (and clearly they nearly always are). Is this a sign of corruption of some sort? Or a common problem with a known cause? Tearing my hair out over this one...
The data is in an .accdb backend on a shared network drive, while each user has their own .accde front end installed locally. We are running Office 365. Users navigate between records on the mainform by typing the product ID into a text field (After Update:
Code:
DoCmd.OpenForm "Edit Products", acNormal, , "ProductID= " & Me.ComboPickProduct, acFormEdit, acNormal