Displaying query results in form area

[wpanssi]

I created a form that displays a drop down list and a button that opens a query which uses a value of the drop down list.

Now when I hit the button it runs a query. But when I hit the button again the query is already open so nothing happens.

I would need to display the query results in the form area and be able to choose another option from the dropdown list and then hit the button again and see the results.

I also created a subform in order to display the query results in the form area but the results don't change if I choose another option and hit the run button. And I don't want to open the query in a separate window at all.

What should I do in order to achieve this?

Thanks!

[OBP]

Add this to the After Update Event Procedure of the Dropdown list

me.subformname.Requery

where subformname is the name of the sub form