I have a form containing data from Table 1 Field A. The Form extracts data from Table 2 using the Form On Current Event and displays the data in unbound Field B. If I click a button the data is copied from Table 1 Field A to unbound Field B. This works ok.
When I move to another record in Table 1 I want to write the data contained in unbound Field B to Table 2 before displaying the next record.
I have tried using various Form Events (Before Update / After Update / On Dirty) but the code to lookup and update the Table 2 record isn't triggered.
How can I trigger the update?
PS. This is a very large complex application so it is not easy for me to provide a copy and there are many fields to which updates may apply on the form.