Query - Listbox

[hedylogus]

On one form, I would like to have an option group to select one of
three queries to run, then have that query's results displayed in a
subform in datasheet format. I can get the queries to run, but I can't
get them to display in the listbox (they appear in popup windows). Any
ideas?

 

[Jeff Boyce]

Have you tried setting the source of the subform to the query selected?

Regards

Jeff Boyce
Microsoft Office/Access MVP

 

[Guest]

If you want the query results to appear in a listbox, you have to assign the
RowSource property to the query and then requery the listbox. You can add a
button that does this. Do all three queries have the same columns?

The erason why they appear in separate windows is probably because you use
the OpenQuery command.

You'll need to programmatically assign the query to the listbox if you want
them to appear in the listbox.

Ray