Passing a value from a control in a form into a Query

[JP]

I have a query that looks at the status field in a backlog
table and pulls those records that have a certain status
field. The query is based on another that has an inner
join between the backlog, customer and order table to pull
line items by company.

I want to pass a value from a drop down list in a form of
all the companys to the query so that it picks out all
the "open" status records from the pull order query.

The two queries are as follows:

SELECT Backlog.*
FROM Backlog INNER JOIN Orders ON
Backlog.order_id=orders.OrderID
WHERE (Customers.Company_ID=Orders.Company_ID);

and

SELECT [Find Company Line Items].*
FROM [Find Company Line Items]
WHERE [Find Company Line Items].Status="S";

When you run the second query just by itself it asks for a
company_id. I want to automate that process by feeding it
from the control box on a form and then outputting the
results into the same form.