How change value in a table when change value in a form not bound to that table
Posted on 2011-04-22
I have a form which is bound to a table, "tblJobScheduleHeader". On this form is a field named "txtJobN" and the control source for this field is JobN which is a number field. The form, by default, opens with txtJobN with 99999999 as the data in that field. When the user changes this number to another number, say 123456, I want the following to happen...
Find, in "tblOutside Purchase", any record with 99999999 in the field JobN and change it to 123456.
How can this be done. I would like it to happen in an afterupdate event of the field "txtJobN"