Calling Parameter Query With SQL

Hi,

I have a query in Access that requires a parameter. (ie when you run the
query in Access, it pops up a parameter box asking for the param value).

If I am calling this query from elsewhere (A report designer), is there a
way of passing the parameter into the query? I know how to do this with ADO
command and parameter objects, but it would seem that in this instance, the
only way so call the query is through a SQL string:

ie: SELECT * FROM MyQuery

Anyone got any ideas? FWIW, it is ActiveReports that I am using, so if
anyone knows how to call a query with parameters in ActiveReports, I would
be most grateful.

TIA,

ChrisM.

--
Please remove shoes to reply

But what ... is it good for?
- Engineer at the Advanced Computing Systems Division of IBM, 1968,
commenting on the microchip.