Issues with Multi Selection Lookups

[Nurse Nancy]

I have 3 problems.

1. I have a form that has a field that is a multiselect lookup. The values
are used as matching criteria in a query. I have the 2 tables joined and
selected (only include records where the 2 fields are equal). If I leave the
drop down null, then no records are returned, but what i want it to do is not
match at all if the drop down is null and return all records.

2. The multi selection has over 100 values to select. If the matching needs
to be on all of the selections,, which would be the same as leaving it null,
if i could get that to work,,,, or If the matching is on let's say 90 out of
the 100, how could i get them all checked instead of making the user select
each one.

3. And what if they are all checked, and the user wants to uncheck all of
them or most of them, how can I facilitate that w/o making them uncheck each
one at a time?


thanks

Nancy

 

[Nurse Nancy]

can anyone help with this,, or is the only answer to change my multiselection
lookup to a combo box on the form and add another table to my database?