Filter listbox by combo box where some text matches

[james_IT]

Hi, I have a listbox which is filtered by combo boxes which works fine - the list box filters when the content of the combo boxes exactly matches data in a column of the list box. I use the following code to filter the listbox:

If Not IsNull(Me.ArtworkSource) Then
strFilter = strFilter & "((ArtworkSource = '" & Me.ArtworkSource & "')) AND "
End If

But now I want a combo box of values which will not directly match any column of the list box. For example, an option in the combo box might be 'Apple' but the data in the list box might say 'Green Apple'.

How do i have a combo box which will filter the list box when the content of the combo box is found in that column (i.e. not an identical match)

Thanks for any help in advance

 

[pbaldy]

Try

strFilter = strFilter & "((ArtworkSource = '*" & Me.ArtworkSource & "*')) AND "