Query / List Box Question

[AndyShuter]

I have 2 listboxes which contain records from a table

What I would like to do is perform a query based on multi selected values from the 2 listboxes

For example

ListBox 1 List Box 2
Accepted Monday
Declined Tuesday
Sumbitted Wednesday

So if I multi s elected Accepted & Declined, Then Monday & Tuesday I would want to return records that equalled that crtiteria

Hope I explained it OK

Cheers

Andy

 

[daveUK]

You will need to use a dynamic query as the criteria will change with each use. Have a look at www.rogersaccesslibrary.com, particulary the 'Create Queries' examples as it shows how to create the type of queries you require.

If you're still having problems, attach a copy of your database and I'll have a look.

HTH