open parameter query in code

[pdbowling]

Hi all
I've got a parameter query. I would like to call it in code, feed it the parameters in code, and show the result set (datasheet). I understand that this is different from retrieving it in a record set (which I can already do).

Example code? Link?

Anything's appreciated.
Thanks everyone
PB

 

[dcx693]

Here's some DAO code: Open Parameter queries from code

 

[pdbowling]

Well, yes. This retrieves a parm query in code.

I understand that this is different from retrieving it in a record set (which I can already do).

This is great code, but unfortunately, it does not answer my question. The data is sent to a record set. i would like to see the data... open it.... show the table,....how should I say? ..open up a window with a grid in it that has the data in it. Sorry to be unclear in my request.

I guess I'll just create a temp table from the recordset but that just seems silly to me. More work. Better suggestions? Magic Spells?
PB

 

[dcx693]

You're right, sorry about missing that vital part. I don't think there's a way to do what you need except (as you already suggested) saving the data to a table and opening it.