Hello, people. I'm designing a search form which triggers a query (nothing unusual).
I have a problem when I use two fields (a text box and a combo box) for the same filter. The user can choose to use the text box or the combo box.
The problem is when the query is triggered, the query simply does not filter. If I remove the or criterion (txEQUIPE) it works. Is there a way to do this?
cbEQUIPE is the combo box, txEQUIPE is the text box:
I had already tried to find something like this and have failed. A screenshot is attached since I haven't made 10 posts, yet.
I have a problem when I use two fields (a text box and a combo box) for the same filter. The user can choose to use the text box or the combo box.
The problem is when the query is triggered, the query simply does not filter. If I remove the or criterion (txEQUIPE) it works. Is there a way to do this?
cbEQUIPE is the combo box, txEQUIPE is the text box:
Code:
Like [Forms]![f-FILTRAGEM]![cbEQUIPE] & "*"
Like [Forms]![f-FILTRAGEM]![txEQUIPE] & "*"
I had already tried to find something like this and have failed. A screenshot is attached since I haven't made 10 posts, yet.