Thanks for your reply John.
I want the mailing fields to automatically update with the residential address to save having to type the address twice.
At the same time I may need to change the postal address: ie for eg. if the member has a post office box number.
I have tried using all the fields in the one table/form - didn't work. I made another table just with the mailing details, then a form (for the mailing address) and created a sub-form in the main form. Both tables seem fine.
The updating is fine - all works - BUT when I want to change the mailing address the residential address also changes and vice versa.
It is becoming very very frustrating :(
Rob