Post Query Info on Form or Subform

[shawnacker]

Hi,
I have created a Form which has cascading list boxes and separate text box which help select criteria for a query which I have created and runs correctly. I would like this query to "print" on the same form just below the selected information. I have tried a subform but I can only seem to get the subform to pop up in its own window...not in the subform on the main form.
Is there a way that I could show the query results below the list boxes? I believe that I would need to rerun the query or automatically update the information once the text box has been updated but I have not been able to find the correct expression or macro to place in the after update field.

Any help would be greatly appreciated.

Thank you in advance.

Shawn

 

[RichMorrison]

Shawn,

Based on what I understand from your post, I think you DON'T want a subform.

You want a continuous form with your various list boxes in the "Heading" of the form.

And yes, you would need to refresh the form RecordSource after the user has selected criteria and clicked on some "Refresh" command button. This requires code in the Click event of the "Refresh" button.

HTH,
RichM

 

[llkhoutx]

Requery a list box after all text boxes have been updated.