Copy values on a form

[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

 

[Rick]

In the OnChange event of the checkbox put something like:

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

 

[Robert Sykes]

Thanks, but there is on OnChange event, I'm using access 2k.

 

[Rick]

sorry, AfterUpdate.

Rick


Thanks, but there is on OnChange event, I'm using access 2k.