Mailing Address and Street Address

K

kuben

Hi

How do I create a button that when pressed will copy the mailing
address info into street address. Some clients have the same address
details.

Thanks

Kuben
South Africa
 
J

John Vinson

Hi

How do I create a button that when pressed will copy the mailing
address info into street address. Some clients have the same address
details.
Click to expand...

On a Form? a Table datasheet? or where?

Assuming that you are (as you should be) using a Form to do your data
entry, and that you have textboxes named txtMailingAddress,
txtMailingCity, txtMailingPostcode; and txtStreetAddress,
txtStreetCity and txtStreetPostcode, use code like

Private Sub cmdDupAddress_Click()
Me!txtStreetAddress = Me!txtMailingAddress
Me!txtStreetCity = Me!txtMailingCity
Me!txtStreetPostcode = Me!txtMailingPostcode
End Sub

John W. Vinson[MVP]
 
Top