Combo Box - Select all/ Select none

[Barkley via AccessMonster.com]

I have a form with a couple combo boxes on them that I am using as criteria
for a query's parameters... I have the path and name of the combo boxes as my
query's criteria... all that is working fine... now what I am wanting to do
is to have an option to 'select or unselect all' from the combo box... any
ideas are always appreciated...

Thanks

 

[KARL DEWEY]

Set the combo box default to Null.
Have criteria ---
[Forms]![YourFormName]![ComboName] OR Is Null

 

[KARL DEWEY]

Fast fingers --- needs to be this --
[Forms]![YourFormName]![ComboName] OR [Forms]![YourFormName]![ComboName]
Is Null

--
KARL DEWEY
Build a little - Test a little

Set the combo box default to Null.
Have criteria ---
[Forms]![YourFormName]![ComboName] OR Is Null
--
KARL DEWEY
Build a little - Test a little

I have a form with a couple combo boxes on them that I am using as criteria
for a query's parameters... I have the path and name of the combo boxes as my
query's criteria... all that is working fine... now what I am wanting to do
is to have an option to 'select or unselect all' from the combo box... any
ideas are always appreciated...

Thanks

 

[Barkley via AccessMonster.com]

Thanks Karl... you guys on here are great... some of the info I have picked
up has been invaluable to me... rogersaccesslibrary is another site I have
recently been frequenting... it seems really good as well... thanks again

Fast fingers --- needs to be this --
[Forms]![YourFormName]![ComboName] OR [Forms]![YourFormName]![ComboName]
Is Null

Set the combo box default to Null.
Have criteria ---

[quoted text clipped - 7 lines]