Limiting Choices in a Combo-box

L

lpd122

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.
 
T

Tellabs T. Burr

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"
 
Top