How to make a selecting matrix form? (1 Viewer)

[ListO]

I would like to create a form with a selecting matrix. One set of records as Column Headers and one set of records as Row Headers, with a grid of checkboxes at the intersections. The user could check or uncheck those boxes, and I would then like to select data which has coincidental checks.

As an example, I might have a database for shoes of many different colors and sizes. The row headers could have the colors, the column headers with sizes. User clicks on the colors and sizes desired, and report could be generated with all the styles which fit those criteria.

I'm not quite sure of the best approach to this. Any terrific ideas?

 

[boblarson]

Maybe this sample will help:

http://www.access-programmers.co.uk/forums/showthread.php?t=162765

 

[ListO]

Bob, you're a wiz with this stuff. Thanks for the great reference.

I'll have to study it a bit, but it appears to be just what I want.