How to update a field in main form on double clicking a field in subform?? (1 Viewer)

[captgnvr]

D/SIRS

I got two tables one with staff names and other with various duties for emergencies.

I made a 'job-dtls-table' with fields name-code from staff-table and job-id2.

I made a main form with 'job-dtls-tbl' with subform which exhibits 'job-tbl'.

I select the name on main form, control moves to the subform, where I will scroll and pick the job code. On double clicking the job code, code to run to update the job-id2 field on main form to the job-id in the subform.

I am getting a message saying that field can not be found.

Urgently need to know and pls advice what I am doing wrong and how to get the field in main form updated to the double clicked field on the sub form.

brgds/captgnvr

 

[captgnvr]

D/SIRS

May be the field in main form was with a text field etc. So I deleted the fields and freshly entered in the main form using the field_list and now seems to be working.

Thread can be considered closed.