I have a form which has tblPartsMasters as its record source. When the vale in one of the fields on the form changes I want that value written to a field in a separate table. Basically this is what I'm trying to accomplish. I need help figuring out what the after update event of the field on the form should be...
On afterupdate event of field “txtPatt_Loc” (control source is [Patt_Loc] in “tblPartsMasters”) on “frmJobCards” update
The field [Patt_Loc] in “tblOpenOrders”
[Part_No] = “txtPartN” on “frmJobCards”