Help with a form and cross tab query

[fireblade72]

Hi - I've just followed a tutorial to create a simple parameter query based on the input received by 2 combo boxes on a form. This works ok, you select the 2 values on the form - the form passes it to the query which runs, the form closes and the query is displayed - all ok.

What I would like to do, is to display the results a bit more elegantly as the end users that will use this little database won't really like to see the query window. Is it possible to display the results on the bottom of the form? So that each time you click "Ok" on the form, it re-runs the query and displays the results. Any help would be great - but you'll have to explain it simply for me as I'm a newbee to all this! Thanks in advance

 

[alastair69]

if you can post an example i will have a look for you.

 

[Fear Naught]

insert a subform which holds the result of the query.

 

[fireblade72]

Qry results into a form

Cheers for replying. Here's a copy. I've tried adding a sub-form but it doesn't work as it keeps asking for the new parameters. Thanks