Filter subform by dropdown

[Marcster]

Hi All,

Using Access 2000.
I have a form with a subform and a dropdown on it.
I want it so that when someone selects an option from the dropdown
it filters the subform with the matching values.
I can set it up to filter from a textbox but I want to use a dropdown.

See attached sample.

Thanks,

Marcster.

[OBP]

Marcaster, if you can do this with a text box then you can do this by having the text box, set to "Invisble" on the form with Combo. Use the Combo's After Update to "update" the text with the selection.
However the correct way to do this is to match the data types of the "CC" field in both tables and then set a relationship between the tables.
You can then set the Master/Child Links between the two forms to CC = CC.
I have also used Queries to suppy the data to the 2 forms as the data can then be "ordered" and "Filtered" in the Query as required.
I have created you this version so you can see it in action for yourself.

[Marcster]

I saw the Master/Child links in the properties, now you've told me how it works, thanks :beerchug:.

Marcster.