Combo Box - Select all/ Select none

  • Thread starter Thread starter Barkley via AccessMonster.com
  • Start date Start date
B

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
 
Set the combo box default to Null.
Have criteria ---
[Forms]![YourFormName]![ComboName] OR Is Null
 
Fast fingers --- needs to be this --
[Forms]![YourFormName]![ComboName] OR [Forms]![YourFormName]![ComboName]
Is Null

--
KARL DEWEY
Build a little - Test a little


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


Barkley via AccessMonster.com said:
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
Click to expand...
Click to expand...
 
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


KARL said:
Fast fingers --- needs to be this --
[Forms]![YourFormName]![ComboName] OR [Forms]![YourFormName]![ComboName]
Is Null
Set the combo box default to Null.
Have criteria ---
Click to expand...
[quoted text clipped - 7 lines]
Click to expand...
 
Back
Top