Monday, August 16, 2010

Microsoft Access Help?!?

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