One combo box to filter another

[roarcrm]

Hi,



On one form I have a combo box that selects district and another that is called services. What services are allowed depends on what district is selected so what I'd like is to only display certain options in the services box depending on what is selected in district.

How can I do this?

Many thanks.

[lfpm062010]

1) If the district and services combo box are on different forms, they both forms have to be opened.
2) Select your district. Then on the services combo box using the district combo box value as its criteria.
On the Row Source of the Property of servcie combo box.
SELECT * FROM TABLENAME WHERE ((([DISTRICT])=[Forms]![districtform]![districtcombobox]));

[nick404]

This tutorial is excellent as well: http://www.datapigtechnologies.com/f...combobox2.html

[roarcrm]

This tutorial is excellent as well: http://www.datapigtechnologies.com/f...combobox2.html

That is great, thank you.

[Missinglinq]

FYI, the concept is usually called 'Cascading Comboboxes,' although the same approach can be used with Listboxes as long as the Multi-Select Property is set to None.

Linq ;0)>