Hi guys. I am sure it is easy and someone allerwdy asked for it, but I just can't Google solution for it.
I have a table and a form to register what is happening witch chemicals - TblChemRegister. And there are informational like: Date, Employee (lookup from another table), Chemical (lookup from TblChemType) quantity that was used (ChemUsage), and a comment what was it used for.
The goal is that when usage is registered (John took 5l of paint), then field ChemQuantity in table TblChemType should be updated (paint - 5).
I would like to do it by some simple VBA code. The one that I tried to use does not work.
ChemType!ChemQuantity = ChemType!ChemQuantity + ChemRegister!ChemUsageCan you guys help me please.