By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
443,492 Members | 1,351 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 443,492 IT Pros & Developers. It's quick & easy.

How to populate Mailing Address if its same as Street Address?

P: 30
Hi Gurus,
I have street address fields as Addr1, Addr2, City, PCode, Prov, Country.
Then I have a check box asking if the mailing address is same as the street address.
How I can populate all the corresponding mailing address fields automatically if someone checks the check box as Yes.
I use mailing address fields as MailAddr1, MailAddr2, MailCity, MailPCode, MailProv, MailCountry.
I really appreciate all the help.
Mar 26 '08 #1
Share this Question
Share on Google+
2 Replies

Expert 2.5K+
P: 3,532
A brief example:

Expand|Select|Wrap|Line Numbers
  1. Private Sub YourCheckBox_AfterUpdate()
  2. If YourCheckBox Then
  3.   Me.mailaddr1 = Me.addr1
  4.   Me.mailaddr2 = Me.addr2
  5. Else
  6.   Me.mailaddr1 = ""
  7.   Me.mailaddr2 = ""
  8. End If
  9. End Sub
Linq ;0)>
Mar 26 '08 #2

P: 30
Thanks a lot.
It worked right away the way I wanted.
You are actually BridgingLinq(K) instead of missinglinq -:)

Take care,
Mar 27 '08 #3

Post your reply

Sign in to post your reply or Sign up for a free account.