Mailing Address and Street Address

[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

 

[Joseph Meehan]

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

Use a button to run an update query. Be sure to filter the query to
just the current record.

 

[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.

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]

 

[toshilim guevara]

no ingih