Data Clustering using Access/VBA

[npatil]

Hello,

I need to build a form which contains groups of combo boxes. Each group contains two or more (cascading) combo boxes which take in data from a single table . Now I need to build the queries in such a way that the user can select different choices from different "groups of comboboxes" (takign in data from the same table) and add them as filters and put them in a listbox.

Finally, a command button is used to run a query which will select these filters and give the output. I want to know if it is possible in access to achieve this without having cascading boxes between "different groups" ?

Is there some database example to help me understand how to approach it?

Thanks in advance,

 

[Red17]

The following links may give you a start:

http://bytes.com/topic/access/insights/605958-cascading-combo-list-boxes

http://www.fontstuff.com/access/acctut10.htm

I have also attached a useful sample that I downloaded from Candace Tripp's site.