I have a members form with a linked member contacts subform (child, spouse, sibling, parent). What I would like to do is: if the user selects that the contact is a spouse or child, have the address auto-fill with the same address as the member. If the contact is any other, the address would remain blank and have to be entered.

I tried to do an iif statement in the on enter property box where the address would pull from the table if the contact of spouse or child was selected, with no luck.

I then tried to do the same iif statement but pull the values from a query with the same result. (error message in both cases was "the object does not contain the automation object".

Is an iif statement in the on enter property the right way to go about this?

Any help would be appreciated!