Shipping Address and Billing Same Button

[KBNETGUY]

I have a form page that includes a section for adding Shipping Address and Billing Address.
I would like to create a procedure that when a button is pressed then the data entered into the Shipping address gets copied into the Billing Address fields.

Similar to whats typically on websites so that a user can save time having to enter the information twice. NOTE: I still need the data entered in both places so having the copy procedure would save time from having to enter it twice.

Any help would be great.

[Beetle]

Assuming you have a form with the following text boxes;

txtShippingaddress
txtShippingCity
txtShippingState (or Province, Region, etc)
txtShippingPostalCode
txtShippingCountry

txtBillingaddress
txtBillingCity
txtBillingState
txtBillingPostalCode
txtBillingCountry

Then you would use a command button with code like the following;

Private Sub cmdYourButton_Click

With Me

   !txtBillingAddress = !txtShippingAddress
   !txtBillingCity = !txtShippingCity
   !txtBillingState = !txtShippingState
   !txtBillingPostalCode = !txtShippingPostalCode
   !txtBillingCountry = !txtShippingCountry

End With

End Sub

You may also want to add a way to undo the copy in case of mistakes.

[Micron]

You may also want to add a way to undo the copy in case of mistakes.

Such as on click, first check the button caption. If it is like "Copy Shipping Address to Billing" then do the copy and change the caption as in "Delete Billing Address Info". A subsequent click finds the caption to not be "Copy..." so you set the second group of address controls to "". There are other controls you could use as well, such as an option or toggle button, though I'd favor the toggle last I think. Then you'd alter a label instead of a button caption based on whether the option value is true or false (-1 or 0).