I am creating a form in Microsoft Access and I would like to create several drop down lists dependent on a prior input. For example: After a user selects a country, the following drop-down list pre-populates with all of the states, provinces, etc. in that country. Anybody have any idea how this is done?
Microsoft Access Help?!?free adware remover
I call that a Drill down query. It is actually simple.
lets say you have a table with
country
state/province
city
burrough
on a form, put a combo box in for each field. now make a select query for the country and make sure the unique values property is set in the query. use this query as the row sources for the combo box,'
make a select query for the state/province box that uses [form]!%26#123;counrty].value in the criteria for the country, and includes the state/province. uncheck the show box for the country field. use this as the row sourcew on the state/province combobox
do the same for the other fields us the value of the previous boxes as criteria in a query, to use a row source for the list..
No comments:
Post a Comment