Query Criteria Command Code to always be a specific value

[BWG3]

I set up a query that has a column that is linked to a table named "Status". The table "Status" has two rows, "active" and closed". I had a criteria command that made a prompt window asking the user to type "1" for active or "2" for closed. Then it would run a report only showing either the active or closed projects. The code is below.

[Enter "2" For Active Or "4" For Closed:]

I only ever want to run a report for "active" projects, so I always want the number to be "1". Is there any code that will eliminate the prompt window so the user doesn't always have to type "1"? Or is there any code that will link the criteria command to a text box in which the default value is always "1"? I just want to eliminate the prompt box window entirely. Thank you in advance.

Brandon

 

[pbaldy]

Take out the bracketed text and just put this as the criteria:

1

 

[BWG3]

Wow. I was trying to be way too technical. Thank you very much.

 

[pbaldy]

No problemo. Once in a while, there's an easy solution.