Re: https://www.accessforums.net/program...orm-41586.html
I'm doing a similar filter. When I search most of the columns I specified works fine but the columns with combobox's will only allow me to search by the autonumber id in the first column. Is there a way when I specify my filter to have it search by say a column in that combobox?
I set the filters in the form first like this:
[Category1] & '|' & [Category2] Like '**' under the Property sheet in Data/Filter
then in my searchbox I go to properties / Event / On change and do this
formname.form.filter = "[Category1] & '|' & [Category2] Like '*" & txtSearch.Text & "*'"
formname.form.filteron = true
But lets say Category1 is a combobox, when I search using it in my list here I can only search by column 0, can I change it to look at all columns or change the column to search? I hope that makes sense.