I have a combo that works with a case statement in access vba to take the appropriate filter action:
Forms!cw_client_matching_form.Filter = "([ComparitorType] =2)" & StrFilterDate
I had to make a structural strange and [comparitorType] could now contain numerous values ie
etc as opposed to one numerical value so how do i change the filter string to reflect that?
like "*2*" ?
if as in my ex