Filter using Multiple/Multi-Column List Box

[zool]

Hi, i'm not familiar with listbox yet and i want to filter my form using it.
I have two separate listboxes which display "category" & "type" data from the same table.

Here is the situation i wanted for my listbox.
1. Select one data from "category" listbox.
2. Then it will automatically filter data from "type" listbox or it will list all related "type" data corresponding to "category" data.


3. Then select one data from "type" listbox and it will filter all related data on the form/sub-form.

Is it possible to do that way?
Can i do it on multicolumn listbox instead of using 2 listbox?

[June7]

Yes to all.

Review
http://datapigtechnologies.com/flash...combobox2.html
http://datapigtechnologies.com/flash...tomfilter.html

If you want only one listbox instead of dependent combo/list boxes, need to reference the column index in the query criteria. Column index begins with 0. So column 1 is index 0.

Forms!formname!listbox.Column(1)