Copy values on a form

R

Robert Sykes

Hello, I have a form built from a table called Customers.
It has fields for the billing address (baddress1,
baddress2, bcity, bprov, bpostal, bcountry) and service
address (saddress1, saddress2, scity, sprov, spostal,
scountry) and an unbound check box control. I want to set
it up so when the box is check the information from the
service address fields are copied to the billing address
fields.

Thanks in advance
 
R

Rick

In the OnChange event of the checkbox put something like:

If CheckBoxName = True then
Me.baddress1 = saddress1
Me.baddress2 = saddress2
Me.bcity = scity
 
Top