Fixed Parameter Value in SQL Statement

[bs0d]

In Access, can I hard code a parameter value to suppress the prompt? I'm querying a query that's made up of sub queries, which all require the same parameter.

I'd like to define the parameter value in my SQL statement so there is no prompt. Can this be done directly in my Access query?

Again, the parameter isn't any part of my main query, it's part of the sub-queries that make up the master query if that makes any sense.


Thanks,

[June7]

Yes, parameter can be static, like:

SELECT * FROM table WHERE Status="Current";

Or for dynamic parameter and no popup, the parameter references a control on a form, like:

SELECT * FROM table WHERE Status=Forms!formname!cbxStatus;