Copy values on a form

  • Thread starter Thread starter Robert Sykes
  • Start date Start date
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
 
In the OnChange event of the checkbox put something like:

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