I'm having some trouble with this line of SQL...
"SELECT Ename, Enumber, Ecolour FROM TestTBL1 WHERE Tick = False and Region = " & myString
What I want the query to do is find the name(Ename), number(number) and colour(Ecolour) and if the happy tick box (tick) is unchecked and there region matches the user input (stored in myString) return the query. No errors seem to be poping up, but the code worked fine and returned some info before I added the "Tick = False". Can someone help me sort the statement out?