Form Method to pick criteria from 3 subforms 2

[molly]

Could you point me in the right direction regarding the following. Maybe their is a white paper or an example. Or at least the terminology to help me search the internet.

I would like to pick choices from 3 groupings that are on a form. The combination would be the basis for a query to run.

For now, I envision 3 subforms on the main form for CatalogueID, PackTypeID and ProductClassID. There are several answers inside each of the 3.

For example, I may want to pick 2 catalogueID's, 3 PacktypeID' and maybe 5 ProductClassID's. It will always vary. Then hit a button for the query to generate.

I am offhand thinking that the picking method of multiple choices within each of the 3 boxes would be using the Ctrl or Shift key ?? don't know.

What Access nominclasure describes my need?
Thanks alot.

 

[PHV]

MultiSelect ListBox

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886

 

[GKChesterton]

These links may be useful:
Prepared search form
About multi-selects and building SQL

[purple]If we knew what it was we were doing, it would not be called
research [blue]database development[/blue], would it? [tab]-- Albert Einstein[/purple]​