Taking a string and converting it onthefly to a query? 1

[linsalad]

Hey all,

I have a little page set up where you can select one or more companies in a list box, click the "add" button, and pop them into the selected companies list box. (I know it's simply, but I'm new to this )

Anyways, what I want to do is compare said companies. Ideally by clicking a "compare" button that triggers a spreadsheet (is the proper term "dynasheet?&quot in a subform on that page.

...but I'm not sure how to take the stuff from the selected item box and create the query on the fly. I don't really even need it in the subform, although that would be nice. Is it possible? Can I generate queries like this on the fly? And if so, can someone either snip me some code, give me a general topic/heading I can use to look it up in my MS Access 2k Bible...or...well, anything constructive

Thank you!!!
Dave

 

[KyleS]

You could convert it to '97, I don't think it will be a problem converting back to 2000 (since the form is the only thing you'll care about). I won't use anything '97 specific, so it should be OK. Kyle