Question Locked

Access: Linking fields in main form with sub-form- Help please

0 helpful
4 replies
Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.

Quite often someone's residential and mailing address differ.
When I change the mailing address in the sub-form, the residential address in the main form also changes. I don't want this to happen.

Any help would be appreciated.
Rob

4 replies

by john.a.wills

Why is one in the subform? And do you have distinct kinds of address defined in your database?

by rob

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

by john.a.wills

Your events seems to be symmetrical, but they should be one-way. Take a look at your event VBA code for changes in the mailing address.

This discussion is closed to new replies.