Check Box

  • Thread starter Thread starter Derrick
  • Start date Start date
D

Derrick

I think what i want to do is simple???

In my database, I have a table & form with company information and another
table & form with contact information. I want to put a check box on the
contact information form.

When it is checked I want it to populates the contact address when it is the
same as the company information, when not checked the different contact
address details can be typed in to the box.

Is this a macro or do I need to type in VBA (which I dont know)
 
Hi Derrick,

You are better off if you do not store the "Company" info a second time in
the "Contact" table.
You only want to store "Contact" info if it is different from "Company"
info. When you want to use
"Contact Info", gather both the Company contact info and the Contact
contact info when it exists in a query and reference the Company or Contact
addresses based on whether or not the Contact info is Null.

Regards

Kevin
 
Back
Top