MS Dbl Click Event

[raffaibardin]

I have problems in understanding this code, can anybody help me ,a Nortwind data creating combox to reducing entry:

Private Sub 1stZIP DbClick (Cancel As Integer0
Dim varCity as Variant, varRegion as Variant, strZip as String

  strZip =Me![1stZip]
  Me![PostalCode]=strZip
  strZip = "'" & strZip & strZip.Colum (1)
  varCity = Me![1stZip].Column (1)
  varRegion = Me![1stZip].Column (2) 
  Me![City] = varCity
  Me![Region] = varRegion

End Sub

[Stewart Ross]

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