contact address and/or billing address

[Kathryn]

Hello

Most of our customers have the same Contact and Billing addresses - but some
don't. I have set up fields for both in separate tables (Contacts and
Billing) and entries on a form for both.

How would I set up the form so that our receptionist can fill in a Contact
address which will automatically fill in the information for the Billing
address if they are the same? I have created a Billing Query/ Report using
the Billing addresses which works well - I just need to work out how to
duplicate the Contact address where necessary so that she can create her
invoices.

Many thanks

 

[Al Campagna]

Kathryn,
I would suggest that both addresses be in the same table. Both
have a one to one relation with each client/contact.

You can place the controls for both addresses on the form.
I usually use a "Copy" button to allow the user to decide whether to
initiate the copy of Contact to Bill.

Then it would be a simple matter of...
BillName = ContactName
BillAddress1 = ContactAddress1
...etc.. for all fields.
--
hth
Al Campagna
Microsoft Access MVP 2007-2009
http://home.comcast.net/~cccsolutions/index.html

"Find a job that you love... and you'll never work a day in your life."

 

[Tom van Stiphout]

On Fri, 12 Mar 2010 02:59:02 -0800, Kathryn

I think the typical scenario is that the user checks a box "Billing
Address same as Contact". In that AfterUpdate event you run an Update
query (assuming the Billing record already exists) and copy those
fields over. Then you requery the form and both sets of addresses show
up.
If the user unchecks the box, you run an Update query that sets those
Billing fields to NULL, and requery the form so the blanks show up.

If you were just building up a Billing record, and you have the
Contact fields on the form, you can simply copy the values:
Me.BillingAddress1 = Me.ContactAddress1 etc.

If you do not have the Contact fields on the form, maybe you can put
them there, invisibly, and the above code still works. Or use a
Recordset object to get them - a bit more advanced.

-Tom.
Microsoft Access MVP

 

[Kathryn]

Many thanks - will give both suggestions a try and see how it goes!

 

[De Jager]

Hello

Most of our customers have the same Contact and Billing addresses - but
some
don't. I have set up fields for both in separate tables (Contacts and
Billing) and entries on a form for both.

How would I set up the form so that our receptionist can fill in a Contact
address which will automatically fill in the information for the Billing
address if they are the same? I have created a Billing Query/ Report using
the Billing addresses which works well - I just need to work out how to
duplicate the Contact address where necessary so that she can create her
invoices.

Many thanks