Auto fill text boxes

[gsrajan]

Please help me. I have five textboxes for husband with the values typed(HustxtAddress1, HustxtAddress2, HustxtCity, HustxtState, HustxtZip). I have five more textboxes for wife. I have a combo box asking whether the spouse's address is same as the husband - with yes or no. If "Yes" is selected, the text boxes for wife is auto filled with the same values of the husband. Please let me know how to do. I tried with combo box change event setting HustxtAddress1=WifeTextaddress1, it fills only the first field and other fields are empty.

Please help. Thank you.

 

[Alansidman]

Try this in the afterupdate event for the ComboBox containing "Yes"/"No"

If me.comboxName = "Yes" then
me.wifeTextaddress1=me.HustxtAddress1
me.wifeTextaddress2=me.HustxtAddress2
me.wifeTextCity=me.HustxtCity
me.wifeTextState=me.HustxtState
me.wifeZip=me.HustxtZip
End if

 

[gsrajan]

It works.

Thanks.