This is a multi-part message in MIME format.

------=_NextPart_000_0018_01C1D0CC.6626F720
Content-Type: text/plain;
	charset="us-ascii"
Content-Transfer-Encoding: 7bit

I have a database with just one table containing info. about customers.I
want to filter them based on their region and the products type they
have.
I want to use two combo boxes so that the user can select the region and
the product type and see the results in a form.
I can't find out how i can combine the values of two combo boxes so that
i can form my query.I am new in Access so i am not sure if it can be
done in an easy way.
Thanks
 
 

This message is in MIME format. Since your mail reader does not understand
this format, some or all of this message may not be legible.

------_=_NextPart_001_01C1D0BE.A410216E
Content-Type: text/plain;
	charset="iso-8859-1"

I assume that region and product type are fields in your table.
 
In that case your query will need to have a value for each in the criteria
row.
 
You can build the query in SQL or you can use the QBE grid to do it - the
grid is easier.
 
Use QBE to build or modify the query and refer to the combo boxes on the
form in the criteria section - 
 
in criteria for region you would type 
 
    forms!mainformname.comboboxname    
 
same for the product type 
 
Whenever you run the query it will then get its criteria from the form.
 
Regards

Richard Gibson

IT Manager

Walkerpack Ltd     01604 760529

-----Original Message-----
From: George Michalopoulos [mailto:georgem@h...]
Sent: 21 March 2002 09:35
To: Access
Subject: [access] combo boxes for parameters to queries


I have a database with just one table containing info. about customers.I
want to filter them based on their region and the products type they have.
I want to use two combo boxes so that the user can select the region and the
product type and see the results in a form.
I can't find out how i can combine the values of two combo boxes so that i
can form my query.I am new in Access so i am not sure if it can be done in
an easy way.
Thanks
 
 
---