Filter subform based on combo box

[ms1202]

Hi,

I am a relative amateur with access so you may find this a simple request but please bear with me if I say anything stupid. I have a database that was set up by someone who I can no longer contact who knows more about databases than I do.

In it there is a form which displays results of a query in a subform. The query just selects certain fields from a table and orders them so that the result is a table showing a summary of each record. One of the fields in the underlying table that is shown in the summary is limited to certain entries. All I want to do is add a combo box to the form so that you can select one of the entries in this field and filter the table displayed in the form by it.

It doesn't feel like it should be as hard as I am making it, but it is really frustrating me! Please help!

 

[Jhitch]

Bind the combobox to the table to show the possible values to filter on. In the query build a parameter based on the selected value from the listbox. Use the onchange event of the combobox to requery the form - this will run the query using the filter selected from the combobox and refresh the form with the new data.

 

[ms1202]

Thanks

That's done the trick. Thank you.