I have made a form and subform, from the same table for data entry.

There are five fields in total of which only two require multiple updates. The other three are reasonably static.

My solution was to build one form with the three static entries, and a subform with all entries.

The three static entries are:
AquaticID
PoolID
EquipmentID

I have written a bit of code to filter the combo boxes and then output the results into the corresponding field of the subform. So far so good.

However, if I change the AquaticID, then the PoolID I get a write conflict warning. How do I avoid this?

I just had the order of events wrong. I solved it