re run query using new combo box selection

[Nih]

I have a database that keeps track of what reports each department in our
company has access to, reports are grouped under different "document groups".
I have a form where I choose a document group from a dropdown menu, then the
second dropdown menu shows me the available reports. I created a query to
only show me the reports that fall under the group chosen in the first
dropdown menu so I can filter out reports that are in other groups.

The form works great for the first selection I make but if I change the
document group it does not re-run the query and show me the reports that are
within the newly chosen group. I have to close the form and re open it then
choose another group.

How can I make it so that clicking on the second dropdown box re runs the
query using the new selection in the first box? I've tried a few "on click"
events but can't seem to get it to work.

Here is an example of what I would like to do:
open form and choose "group A" in combo box 1
click on combo box 2 and choose the report I want (from group A)

Change value in combo box 1 to "group B"
click on combo box 2 and choose the report I want (from group B)

 

[Nih]

I guess what I am asking is how do I set it up so a query will re-run when
you change the value in the combo box that is used to feed the query?

 

[Nih]

Nobody? I have been working on this for 2 days and still cannot get the
combo box to display the new query results.

If I manually run the query it updates with the new value entered in
combobox1 so the query works, it's just that combobox2 only shows the results
of the first thing that is entered in combobox1, it does not refresh when you
change the value. I have tried every "on click, on change, etc" command I
can think of but the damned combo box will not refresh.