combo select some or all How?

[LJG]

Hi Guys,

Anyone advise how I can create a combo box that allows me to select either a
one or more or ALL items from a combo box fro a report.

TIA

 

[fredg]

Hi Guys,

Anyone advise how I can create a combo box that allows me to select either a
one or more or ALL items from a combo box fro a report.

TIA

You can't.
You can only select one item from the combo box drop-down list.

You can add the word "<All>" to the combo box list and then use that
selection to report on all records (you would do that using a Union
Query).
Then change the query criteria to:

Like IIf(forms!FormName!ComboName = "<All>","*",
forms!FormName!ComboName)

If you need help with the Union query, post back with your current
combo box SQL.

 

[Scott]

combo boxes only allow you to select one item. That said you can add an
option to your combo box that selects all, but there is no way to select
only certain items