Link to home
Start Free TrialLog in
Avatar of Karl001
Karl001Flag for Canada

asked on

multiple value selected in a combo box

I use a combo box as a filter.

          stFiltInstNo = "[idInstitution] = " & Me.filtInstNo & " AND "
          …
         Me.Filter = stFiltrer
         Me.FilterOn = True
   
 I would like to select multiple values in the combo box.

I tried to use MultiValued Field (MVF), but I don’t know how to extract values.
How can extract the values?

Is there a better way to do it?

Thanks
ASKER CERTIFIED SOLUTION
Avatar of Simon
Simon
Flag of United Kingdom of Great Britain and Northern Ireland image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
You cannot perform multiple selections in a combo box.  You must use a listbox, or could use a subform in either continuous or datasheet format.  These later examples will involve some additional code, but are much more flexible.
Avatar of Karl001

ASKER

Hi Dale,

Which "later examples"?

thanks
SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of Karl001

ASKER

Thanks