Need to copy information between fields when checkbox is selected

G

Guest

I have two sets of fields on two different tabs of one Tab control in my
form.

The first page includes basic shipping information (name, address, phone,
etc) and the second includes basic billing information (name, address, phone,
etc.). I want to put some kind of a check box on the billing page that I can
click if the persons information is the same for both (same name, address,
phone etc for both shipping and billing). When I click the check box, I want
it to automatically fill the billing information with the information that
was listed under shipping (for the respective fields). Is this possible?
and if so, how?
 
S

Steve Schapel

Stacey

Do you mean all of these fields are in the same table?
Maybe something like this on the After Update event of the checkbox...
If Me.NameOfCheckbox Then
Me.BillingName = Me.ShippingName
Me.BillingAddress = Me.ShippingAddress
Me.BillingPhone = Me.ShippingPhone
End If
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top