Filter Information via combo box

[Nasher]

How do you get a combo box to filter the information a user can select in another combo box.

Basically i have a orders form where users select a location from a combo box. i then have a second combo box to select the sub location.

I want the user's selection in the first combo box to then only display the sub locations for that location in the second combo box.

I know there is a simple way of doing this but i cant remember how to.

[MikeTheBike]

How do you get a combo box to filter the information a user can select in another combo box.

Basically i have a orders form where users select a location from a combo box. i then have a second combo box to select the sub location.

I want the user's selection in the first combo box to then only display the sub locations for that location in the second combo box.

I know there is a simple way of doing this but i cant remember how to.

Hi

You need to have a WHERE condition in the second Combo Box RecordSource based on the value selection in the first Combo.

In the AfterUpdate event on the first Combo you need to Requiry tthe second Combo.


HTH


MTB