Hi,
I am new to this forum and access 2010. I have created a table in which I imported an Excel file (it included all the info I needed). I have also created a query and a form. I used the Split Form, so far so good. I added a Text Search Field and a Search button. I chose the Search button, clicked on it, chose macro but somehow I couldn't make it work with two statements in Where Condition.
For example: the code I wrote in Where condition was [COMPANY] Like "*" & [Forms]![qr-BWTS]![Text87] & "*"
When this code was by itself it worked great but when I added a second statement it ignored the second one and didn't show any results.
For example: [COMPANY] Like "*" & [Forms]![qr-BWTS]![Text87] & "*" Or [STATUS] Like "*" & [Forms]![qr-BWTS]![Text87] & "*" ignored the "Or" statement and didin't return anything when I typed something from the STATUS field...
I did one more thing which was that: I deleted the second statement and I left the first one, only I replaced COMPANY with STATUS. It didn't work either!!!
The macro was: [STATUS] Like "*" & [Forms]![qr-BWTS]![Text87] & "*"
COMPANY is the second column (first is the ID) and STATUS is the 12th column... Something wrong with the macro or the columns ?
Any help would be really appreciated