Value added to a seperate table

[MrMitch]

Tables:
POs
Cos

Form:
frmCO
frmPO

In the PO table there are records per "site" that have a "POCurrentAmount" field. When the "frmCO" is filled out, it has a "COAmount" value that is stored in the COs table, which I would like to be added on top to that POCurrentAmount field in the POs table as well.

Is there a way to trigger this event when the frmCO's record is saved?


How would I go about doing this?

Any help would be appricated. Thanks, and let me know if you need more info, as I seem to get confused reading and trying to explain this myself..haha.

 

[MrMitch]

Thanks for the info. After doing a bit of reading, and trial and error, I have an update query doing this for me. Phew!