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

MS Dbl Click Event

P: 1
I have problems in understanding this code, can anybody help me ,a Nortwind data creating combox to reducing entry:
Expand|Select|Wrap|Line Numbers
  1. Private Sub 1stZIP DbClick (Cancel As Integer0
  2. Dim varCity as Variant, varRegion as Variant, strZip as String
  3.  
  4.   strZip =Me![1stZip]
  5.   Me![PostalCode]=strZip
  6.   strZip = "'" & strZip & strZip.Colum (1)
  7.   varCity = Me![1stZip].Column (1)
  8.   varRegion = Me![1stZip].Column (2) 
  9.   Me![City] = varCity
  10.   Me![Region] = varRegion
  11.  
  12. End Sub
Sep 29 '08 #1
Share this Question
Share on Google+
1 Reply


Expert Mod 2.5K+
P: 2,545
Hi. If you could post a question for us to answer I'm sure we'd be delighted to help - but what you have posted is not really of assistance to us so far.

Firstly, you appear to have hand-transcribed some code - there are obvious errors which you appear to have introduced, aside from the even more obvious typos in your code. There is an error in line 3 for example, where you refer to the column property of a variable that appears to be a string - strings simply do not have column properties, so this line cannot be correct.

Second, you have not said what it is you want assistance with. Presenting a piece of code and saying 'help me to understand it' when you don't tell us anything about whatever it is you do not understand is not helpful to us or you.

Please repost when you feel ready.

-Stewart
Sep 29 '08 #2

Post your reply

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