I have two addresses, a MailingAddress and PhysicalAddress and a checkbox hmmm.

[jordancemery65]

I have a MailingAddress City State and Zipcode Then I have a PhysicalAddress PhysicalAddress PhysicalCity PhysicalState and PhysicalZipcode Then I have a checkbox AddressesAreSame I was wondering how I could get the addresses to equal eachother when the checkbox is checked???? Could someone please help?

[Bob Fitz]

If you have this on a form you would need some code in the After Update event of the checkbox control to fill the control which has no data.

[jordancemery65]

I found this somewhere else... but i have no idea where to use it!!!!!!!!

= Private Sub [AddressesAreSame]()
If [AddressesAreSame] Then
[PhysicalAddress] = [MailingAddress]
[PhysicalCity] = [City]
[PhysicalState] = [State]
[PhysicalZipcode] = [Zipcode]


Else
[MailingAddress] = ""
[City] = ""
[State] = ""
[Zipcode] = ""


End If
End Sub

[jordancemery65]

HEY I DID IT!!!! WOOT WOOT! It works!! Thank you guys so much!!!!