I am attempting to build a query that returns customers based on two
criteria: (1) state of residence and (2) type of product. All customers
only have one state of residence but can have multiple types of products.

It is important to note that: When entering a customer, the state is
selected by choosing the appropriate abbreviation in a combo box on the
"Customer_Information" form. This combo box subsequently fills the field
C_STATE with the abbreviation. The product types are then selected by a
clicking the appropriate check box. Each check box is tied to it's own
field. So, if a customer manufactures products 1 and 5, field P_1 and P_5
are populated with a "-1."

For my query, I want the user to be able to select multiple states and
multiple product types. For example, to conduct a query that returns all
customers in PA and NY that manufacture products 1 and 5.

I'm having a problem when it comes to setting up the query and linking it to
a form. I ideally want to have a list box of all state abbreviations and a
series of checkboxes each corresponding to product types. The user can then
highlight the states desired in the list box and check the appropriate
product types.

I've been referred to two websites
(http://www.mvps.org/access/forms/frm0007.htm and
http://www.microsoft-accesssolutions...ng_listbox.htm) they
were both helpful; however, they do not answer my question as to how I can
create a query with inputs from a form that have various components.

What is the best way to accomplish this task?

Thank you very much for your help. Any assistance is greatly appreciated.

LB