I have a form that has 2 listboxs.... The selection of each listbox is passed to a qu

[Drumhead82]

I created 2 forms. the first form passes criteria to a query. I have a macro button that runs the query passing to info from the First form to the query. This is working just fine. Now I'm trying to get the results of that query to populate a second form which is then included on the first form as a Subform.... is this possible?

[Seth Schrock]

Yes it is possible. Are you just using the list boxes to filter the results or you doing any changing of fields in your list boxes?

[Drumhead82]

The list box(s) I created the criteria and stored it as the row source in the value list. I'm using 2 list boxes. They are not linked to any table. choosing a value in each list box gets passed to the Query I built. The query runs when a Control button is depressed running a Macro. They query runs great and I get back exactly what was asked in list boxes each time. Now I would like to have the results of this query show up in a SubForm attached to the Main form that supplies the criteria(when selected) to the initial Query. I have a 2nd form created and one of the features of the Macro is to open the 2nd form and populate it with the results of the query. it works but i can't seem to get this second form with the query result to show in the attached subform. I'm sure I have to have a procedure that requery's or some sort of after event. I'm looking to have this 2nd subform populate dynamically when the initial query is activated. I know I'm getting close but I've hit the wall with the my level of understanding. I'm not a programmer but I can understand some coding.. Any help suggestions is greatly appreciated.

[Seth Schrock]

That doesn't quite answer my question for sure, but I think that I know what the answer is that you are not dynamically building a query (changing field, etc.), but just filtering the results based on your selections in the listboxes.

If that is the case, then as long as your query is set to have its criteria based on the values of those controls, then all you need to do is have your button's OnClick event do a requery of the subform.

Me.SubformName.Form.Requery

Unfortunately, I don't know how to do this in a macro.

[Drumhead82]

Yes the List Boxes act as filters in the query

[Seth Schrock]

What do your macros do currently?

[Drumhead82]

Seth, Thank You very much I added your code string to my procedure with my form information and it's now working as invisioned. I know it was something simple like one line of simple code. Part of the code looks to the Macro and runs that portion and closes. Then the procedure takes over and reloads the query into the Subform dynamiclly.

thank you much. I'm sure I'll be back with more questions.

[Drumhead82]

The Macro Opens a specific Query and runs with the criteria sent from the listbox(s) on the Main Form....then it Closes the query. This stops a seperate Query window from popping up.... and then Stops the Macro.
At this point the procedure takes over and Re query's the Form (Sub-form) and the Sub-form Populates dynamically. If you change your selection in any of the list boxes and hit the query button the sub-form loads with the new information dynamically. This is what I was looking to have happen.

Thank You Again.