V
VNoelDavis
I need to know how to copy a value in a field from a sub form to a field in
the main form. My main form is called Collection. The field I want to copy
to is Task#(New). The sub form is called Tasks by CMPO. The field on the
subform that I want to copy from is also Task#(New). The subform is linked
to the main form by another field called CMPO#. On the main form this field
is a drop-down list that filters the record set in the sub form. When a
value is selected, the filtered record set displays. I would like to be able
to click on a field in the sub form and the value automatically display in
the main form field.
the main form. My main form is called Collection. The field I want to copy
to is Task#(New). The sub form is called Tasks by CMPO. The field on the
subform that I want to copy from is also Task#(New). The subform is linked
to the main form by another field called CMPO#. On the main form this field
is a drop-down list that filters the record set in the sub form. When a
value is selected, the filtered record set displays. I would like to be able
to click on a field in the sub form and the value automatically display in
the main form field.