Form Question - Duplicating fields if check box is checked

[Guest]

I have a question! I have created a check box for an Access Database, and my
hope is that once the box is "checked", the busstreet1, busstreet2, buscity,
busstate, and buszip, will duplicate to the homestreet1, homestreet2,
homecity, homestate, and homezip.

Basically, we have a business address fields and home address fields. If
the data entry person wants to save time and the addresses are the same, the
person can click the box, and the information will populate.

Can someone help me creat this rule or macro or expression - whatever.
please make the instructions easy, i.e. In the Properties of the checkbox,
under the field Validation Rule, etc...

 

[Nikos Yannacopoulos]

Brandy,

I would work on improving the design instead, so no address data is
duplicated; data duplication is incompatible with the whole notion of
relational databases. Under the current design, duplication is not only
due to persons having the same address for business and home, but also
for several persons sharing the same business or home address. Consider
this design instead:

* create a tblAddresses table, with fields: AddrID (autonumber),
Street1, Street2, City, State, Zip;
* in the persons table, remove all the relevant fields, and add two
numeric fields, BusAddrID and HomeAddrID;
* link the two AddrID fields in the perons table to the AddrID field in
the addresses table.

This way, if you have 5 people living in the same address, or 100 people
working in the same address, you only need to type it once! Also, if a
company moves to a new address, you only need to change one address, vs.
as many as the people working there.

Following that, you will have to work on your user interface, so when
the user enters a new person, they can look up an address and pick up
its AddrID if it already exists, or add a new one if it does not.

HTH,
Nikos