Good morning.
I'm writing on the behalf of my company. First we would like to apologise for our colleague's behaviour but there has been a huge misunderstanding. We are building a very large database in Access 2010 and we are dealing with some serious deadlines. It's the first time we are using it so we would appreciate some assistance.
We have created a table in which we imported an Excel file (it included all the info we needed). We have also created a query and a form. We used the Split Form, so far so good. We added a Text Search Field and a Search button. Then we chose the Search button, clicked on it, chose macro but somehow we couldn't make it work with two statements in Where Condition.
For example: the code we wrote in Where condition was [COMPANY] Like "*" & [Forms]![qr-BWTS]![Text87] & "*"
When this code was by itself it worked great but when we 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 didn't return anything when we typed something from the STATUS field...
We did one more thing to test it which was that: we deleted the second statement and we left the first one, only we 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 ?
Sorry again for the mess that has been caused, good faith is above all so any help would be really much appreciated.
Thank you in advance.
Nikos Platis
IT Manager