Filtering List Boxes and Forms based on Multi-Select List Box

[Guest]

I am creating a data entry form and I have 4 Multi select list boxes on a
form that the end user will use to specify which records to pull for data
entry.

Box 1= Customers, Box 2= City, Box 3= Brand, and Box 4= Package

I need to filter box 2 based on criteria selected in Box 1 and I also need
to filter Box 4 based on criteria selected in Box 3. All of the list boxes
are multi-select boxes.

Once the end user makes all their selections they will click a button to
open a data entry form based on all the selections made in each of the list
boxes.

Is this possible and if so, how do I do it?

 

[Guest]

Hi

Maybe this can help:

http://www.mvps.org/access/forms/frm0007.htm

In the example shown on that page you could use the strSQL string as a where
condition for the second listbox etc...

Yeroon