Can someone help me write a script? What I have is a dropdown list
(named Relation1) with three options; Self, Spouse and Significant
Other. A subform1 and a Subform2, each of the subforms have the same
fields. The end-user would first fill out all the fields in the
subfrom1, then they would come to the dropdown list 'Relation1' - say
the select 'Self', what needs to happen is the fields in subform2
prepopulate with the end-users info they typed into the fields of
subform1.Here is what my Hierar...