NearImpossible
Registered User.
- Local time
- Yesterday, 19:17
- Joined
- Jul 12, 2019
- Messages
- 225
I have a FacilityNames table with a FacilityID and Facility Name column, I also have a FacilityEquipment Table with several fields and they are related by the FacilityID.
From time to time we need to transfer equipment between facilities so I am just changing the FacilityID for the selected equipment based on the value in the TransferToFacility column.
After running the following Update Query, when I go back into the form that holds the FacilityEquipment table, I am getting a Write Conflict Error whenever I try to select another device to transfer via the Equipment Transfer Checkbox.
I am also running Me.Refresh in the Equipment Transfer Checkbox After Update event, If I comment that out, it I don't get the Write Conflict error, but also the change is not reflected in my table to show the checkbox as being checked
Can someone shed some light on what i'm doing wrong?
From time to time we need to transfer equipment between facilities so I am just changing the FacilityID for the selected equipment based on the value in the TransferToFacility column.
After running the following Update Query, when I go back into the form that holds the FacilityEquipment table, I am getting a Write Conflict Error whenever I try to select another device to transfer via the Equipment Transfer Checkbox.
I am also running Me.Refresh in the Equipment Transfer Checkbox After Update event, If I comment that out, it I don't get the Write Conflict error, but also the change is not reflected in my table to show the checkbox as being checked
Code:
UPDATE FacilityEquipment
SET FacilityID = FacilityNames.FacilityID
FROM FacilityEquipment, FacilityNames
WHERE FacilityNames.[Facility Name]=FacilityEquipment.TransferToFacility AND FacilityEquipment.[Equipment Transfer]=1
Can someone shed some light on what i'm doing wrong?
Last edited: