DLookup Function for City/Region/Country?

[cap.zadi]

Hi,

I have three fields on a Customers form "City", "Region" & "Country" where "City" field is sourced from a table "tblecity" which have the following fields:


tblecity

CityID
CityName
Region
Country

to reduce the entry work, i am looking to code DLookup function where i just select the city and other two fields must be populated itself.


please advise.


Zee

[orange]

What exactly is the question?
Have you considered a combo box and using the On Change Event?

If you do a DLookup on City, how do you differentiate same city name in different regions or Country?

Kingston Ontario Canada
Kingston New York USA
Kingston Pennsylvania USA
Kingston New Hampshire USA

[cap.zadi]

Sir,

Yes had a combo box which supplied data from Tblecity.

Data is stores like:

Riyadh Central Region Saudi Arabia
Dammam West Region Saudi Arabia


please advise needful

thanks

zee

[orange]

Do you have a question?
Have you considered a combo box and using the On Change Event?

[amrut]

Here is an easier alternative.
I am assuming CityId is your primary key. Create a combo box having rowsource "SELECT CityID,CityName,Region,Country from tblCity ;" and 4 columns having widths 0cm;4cm;0cm;0cm so that only Cityname is visible. Then you can use YourComboboxName.Column(2) and YourComboboxName.Column(3) as controlsource for controls(unbound) used to display Region and Country respectively.

[orange]

amrut,
How is that different than post#4?

[amrut]

orange,
The only difference is no VBA code is required to populate the region and country fields. Please correct me if I am wrong as I am not an access expert and still on a learning curve.