This is similar to the nwind database products and categories, but cant get
that to work either.
When I select a country it works well (picklist based on the country table),
in the form the data entry field is called countryctl bound to countryid
SELECT DISTINCTROW Bikemeets_country.Countryname, Bikemeets_country.
Country_ID FROM Bikemeets_country ORDER BY Bikemeets_country.Countryname;
I now want to select the county, but only have a subset based on the country
I have put the following in the country picklist after update event, as
suggested by this forum
I.e Select England and only the english counties show.
Me.Countyctl.RowSource = "SELECT countyname FROM" & _
" county WHERE county.CountryID = " & Me.countryctl & _
" ORDER BY countyname"
Me.Countyctl = Me.Countyctl.ItemData(0)
The county picklist (countyctl) is not bound, but I have set bound column to
2 as pr nwind, but I dont know why!!, also I dont know what itemdata(0) does
in this case
The countyctl picklist comes up empty
What I want it do do is show the county selected and store it in the county