Limiting Choices in a Combo-box

[Guest]

I am trying to find out how I would limit the selections on one combo box,
based on a previous selection from another box. I want the user to select a
county and in the next box, only the cities in that county to show. I can't
remember how it's done.

 

[Rick B]

Do a search. Asked and answered all the time. Look for "cascading combo".

Rick B

 

[George Nicholson]

http://support.microsoft.com/default.aspx?scid=kb;en-us;289670
How to synchronize two combo boxes on a form in Access 2002 or in Access
2003

The article also includes links to Access 97 and 2000 versions of the
article.

HTH,

 

[Guest]

Under "Data" you can use a query to define the "Row Source" values for the
combo box by setting criteria in the query limit based on the county.

For instance your criteria may look something like this.

IIF(Form![Formname]![Combobox1] isnotNull, Form![Formname]![Combobox1],
Table![Counties]

Define Counties as your first column and Cities as your second coloum. Then
you will need to change the "Bound Column" and under "Format" change "Column
Count" and "Column Widths"