Combo Box - Select all/ Select none

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Barkley - 24 Oct 2007 17:36 GMT

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

Reply to this Message

KARL DEWEY - 24 Oct 2007 19:36 GMT

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

Signature

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
[quoted text clipped - 3 lines]
>
> Thanks

Reply to this Message

KARL DEWEY - 24 Oct 2007 19:40 GMT

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

Signature

KARL DEWEY
Build a little - Test a little

> Set the combo box default to Null.
> Have criteria ---
[quoted text clipped - 7 lines]
> >
> > Thanks

Reply to this Message

Barkley - 24 Oct 2007 20:14 GMT

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]
[quoted text clipped - 5 lines]
>> >
>> > Thanks

Reply to this Message