Selecting a City name and region and country must be auto filling.

[cap.zadi]

Hi there,

I have a form where 3 field for the customers to fill in "City" , "Region" and "Country". how is it possible if i just select a city name so the region and country can be auto in the form fields?


hope to hear.


regards

zee

[JoeM]

One way is to use a DLOOKUP statement in the "After Update" event VBA code of your City field to look up and populate the other two fields.
Here a tutorial that deals with both topic, not too dissimilar from what you are trying to do.
http://www.youtube.com/watch?v=ZmcGl...feature=relmfu

[cap.zadi]

Thanks. it works.