It would limit the list in the combo box if it had a WHERE clause.
The SQL statement given does not agree with the statement you made in post #1
I have a combo box "result" - Fields are [ResultID]*, [resulttext], [card] - all write to a table "Result"
When you said, "Fields are [ResultID]*, [resulttext], [card]" I assumed you meant these were the columns so I expected the SQL to be more like:
Code:
SELECT Result.ResultID, Result.resulttext, Result.card
FROM Result;
This needs to be clarified before you can add the WHERE clause.