Using ApplyFilter with multiple columns for search

[okan]

Hello Accessforum



I' have made a "split-form", and i have there a "listbox" with few entrys. With a button I should start searching the for selcted entry in my database.
I used the Macro "ApplyFilter" here to, like on the other buttons in my Form.
But the difference to the other buttons is, this new button should search in multiple columns. But I have no Idea how to write the correct condition.

Summary:
My problem is, can I specify more than one column for searching the entry in the Listbox with "ApplyFilter"?

My code that always worked with one column:
[Hauptverantwortlicher] Like "*" & [Forms]![MasterQuery]!
[ListVerantwortlichkeit] & "*"

I have tried to specify more than one column with the "or". But it doesn't work.:
[Hauptverantwortlicher] Or [Stellvertretung] Like "*" & [Forms]![MasterQuery]!
[ListVerantwortlichkeit] & "*"


Can someone help me?

[June7]

Are they both text type field?

Use AND operator along with the same LIKE criteria under each field.

Use the Access query builder to test.

[okan]

Hello June7

I'm not sure that I have understand you correctly.
I want to build an "or" expression, not an "and".

Or do you mean maybe I should add few new action's for each column?

can you please make an example?

[June7]

Then try OR operator with the same criteria under each field and see if you get what you want.

[Hauptverantwortlicher] Like "*" & [Forms]![MasterQuery]!
[ListVerantwortlichkeit] & "*" Or [Stellvertretung] Like "*" & [Forms]![MasterQuery]!
[ListVerantwortlichkeit] & "*"

[okan]

Oh thank you very mutch....
You're a genious!!!