Filtering a report from multiple option groups and multi-select list boxes

[Jeff]

=====
ISSUE
=====
1-How do I create a report based on MULTIPLE option groups and
multi-select list boxes?
2-How do I make a multi-select list box default to selecting ALL the
choices?

=======
EXAMPLE
=======

A picture of how I want my option groups/list boxes is here
http://www.huntercomputerinc.com/pics/report.jpg


Table description below...

Note: One to many relationship (Table 1 --> Table 2).
Note: Tables have many more fields than shown.


-------
Table 1
-------
ID: Autonumber
Types of Fields: Multiple Yes/No, Value List, etc.



-------
Table 2
-------
ID: Number
Types of Fields: Multiple Yes/No, Value List, etc.




==========
BACKGROUND
==========
O/S = Win2k Pro
Patches Installed

Software = Access 2000
Patches Installed


=========
Thanks!!!
THE END
=========

 

[Larry Linson]

=====
ISSUE
=====
1-How do I create a report based on
MULTIPLE option groups and
multi-select list boxes?

You write, or hire someone to write, VBA code that uses the contents of the
different option groups and multi-select list boxes to build either a
WhereCondition argument for DoCmd.OpenReport or the SQL that you pick up in
the Report's Open event to replace the RecordSource. If you have a lot of
records, the second approach may improve performance.

2-How do I make a multi-select list box
default to selecting ALL the
choices?

In your code, if nothing is selected, use them all.

Nice picture... is it a screen shot of the Form you designed, or did you go
to the trouble of creating a Form design in some image-processing software?

You didn't really expect someone to write all the code here, did you? Even
if they wanted to, the picture of the Form doesn't give them the names of
the Controls to use in that code, nor does the description. I don't think
it's worth your while to post them in a follow-up, though, because that may
be a little much to ask in a newsgroup post.

Larry Linson
Microsoft Access MVP