How to filter City Names based on Province selected in Province Combo box?

[Yousaf Shah]

Hello guys
Suppose we have got a table named "Province" with its fields; 'ProvinceID' and 'ProvinceName' and a 2nd Table named "City" with its fields; 'CityID', 'ProvinceID'(connected with "Province" Table through one to many relationship) and 'CityName'

Now my question is that while entering the data through a form, is it possible to filter City Names of a Province in City Combo box on Form when Province Name has been selected in Province combo box...???

Please elaborate with some detail as I am very new with Database and want to make my own myself....!

[patjones]

Hi Yousaf,

There are two steps that you need to take in order to accomplish this. The first step is to build a query that selects all the cities for a given selection from the Provinces combo box. The most transparent way of doing this is probably to use Query Design view.

The second step is to use the After Update event of the Provinces combo box to set the row source for the Cities combo box to the query that you built.

Such an arrangement is called cascading combo boxes, by the way. This is the general method for accomplishing cascading combo boxes. If you are unfamiliar with Access, I suggest studying how to use Query Design view, After Update events, and how to set combo box row sources.

Pat