Multi-Select List Box based Query

[DubaiDave]

It has taken me three days to try to embed a multi select list box into my already quite complex, but working query.

I have a VBA routine that collects the selected values and places them in a text box txtTaskQuery on my form. A command button then requeries the form.

The format of txtTaskQuery is (eg):

For a single value 3
For a multiple value 3,4,5

In the query design grid I have

[tbRFIs].[TaskID] In ([Forms]![fmRFI_QBF]![txtTaskQuery])
Expression
True

It works for a single value, but not any multiple values.

Where am I going wrong? I am pulling my hair out over this!!

Dave

 

[HiTechCoach]

Dave,

Check out this example:
Creating a Query that uses a Multi-select Listbox as Criteria

 

[DubaiDave]

Dave,

Check out this example:
Creating a Query that uses a Multi-select Listbox as Criteria

Boyd,

This looks very interesting. I shall have a play with that and see if I can make it fit what I am trying to do. Thanks for posting that link!

Dave

 

[DubaiDave]

Boyd,

This looks very interesting. I shall have a play with that and see if I can make it fit what I am trying to do. Thanks for posting that link!

Dave

Boyd,

Fantastic, this has provided all the answers!! Cheers. David

 

[HiTechCoach]

Boyd,

Fantastic, this has provided all the answers!! Cheers. David

Dave,

Glad that worked for you.

Cheers.