Using multiple selection on combo box as criteria for a query

[iamthebestuk]

I know to use a combo box on a form to set criteria for a query:
[Forms]![form_name]![field_name]

However, I cannot apply this code in the query when I use the multiple selection option for the combo box ie. the combo box contains more than one highlighted value.

.... just get a blank result

Any suggestions?

Tks

 

[dhookom]

I wasn't aware you could make multiple selections in a combo box. If you mean list box, check the FAQs in either this forum or the Access Reports forum for some samples.

Duane MS Access MVP
[green]Ask a great question, get a great answer.[/green] [red]Ask a vague question, get a vague answer.[/red]
[green]Find out how to get great answers faq219-2884.[/green]

 

[iamthebestuk]

Yeah sorry - I meant list box!

 

[iamthebestuk]

I've check out both suggested FAQs - but it did not help.

Is there not a query solution to this problem - or do I have to use VB code?

 

[KenReay]

Hi

Try "use multi selection list box as query criteria" as a search criteria in Google, this will give you numerous examples, including the perfectly good ones from tek-tips FAQ's, plus Microsoft and others, complete with code snipits

Regards

Ken Reay
Freelance Solutions Developer
Boldon Information Systems Ltd
Website needs upgrading, but for now -

http://www.kenneth.reay.btinternet.co.uk

UK

 

[dhookom]

I believe coding is the only solution for using a multi-select list box.

Duane MS Access MVP
[green]Ask a great question, get a great answer.[/green] [red]Ask a vague question, get a vague answer.[/red]
[green]Find out how to get great answers faq219-2884.[/green]