Query in subform

[voiD]

Hello,

I assume, I've already asked here something similar, but I didn't receive answer. So, I have many queries in a list and when user double click on an item I would like to display the result of the query in a subform control. I tried to assign the query in runtime to the subform's SourceObject property, but I always get the error message. Is it possible anyway to set query as source object of a subform? If not, does anyone have idea for any well usable alternate solution?

Many thanks in advance for everybody!
voiD

 

[rainman89]

you could make a subform based on each query and based on what value is selected in the box make that subform visible????? just a suggestion.

 

[boblarson]

Actually, you can set the source object of the subform container, if you have different subforms, or you can set the recordsource of an existing subform by setting it via code, but if the fields are not the same as the ones for the controls you would also need to set, via code, the recordsource of each control.

 

[voiD]

Thnks Ray for the suggestion, but unfortunately it doesn't work, because on one hand currently I have more than 50 queries and the number is growing according to new demands. On the other hand I am looking for a solution which is 'dynamic' and in case of a new query it is enough to add the new query to the program without any plus program or design changes.