Help required 3 Cascading List Box: one filtering the other

[suprakashG]

Hi,
I need some help in this cascading list box problem....I browsed through the
posts for cascading list boxes but being pretty novice couldn't resolve my
problem. Here it goes....

Table 1:
countryID_PK (Text)
countryName (Text)

Table 2:
stateID_PK (num)
stateName (Text)
countryID_PK (Text)

Table 3:
CityID_PK (num)
cityName (Text)
stateID_PK (num)

Relationships:
Table 1>>Table 2 is 1-Many
Table 2>> Table 3 is 1-Many

I have three List boxes called lboCountry,lboState,lboCity.I want the values
of lboState to get populated based on the country selected in the lboCountry
and subsequently the lboCity to get populated based on the state selected in
the lboState. Here as usual City is a State is a subset of Country and a
superset of City.... Please help me out

 

[Guest]

Microsoft's How-to article covers this quite well. take a look at

http://office.microsoft.com/en-us/access/HA011730581033.aspx?pid=CH063650361033

Daniel