Search not working with WHERE clause
Please see attached.
Basic stuff... I have a database with articles and a form to search with. The search form has 4 drop down menus. The search function seems to work correctly. My problem is that on the rsArticles recordset, I need to sort the results by active = 1. In the database, a column named active is either 1 or 0. 1 is active, 0 is not. So if my recordset is SELECT * FROM articles, then the search function works correctly. If I change my recordset to SELECT * FROM articles WHERE active = 1, then the search results return ALL records that are marked active regardless if they meet search criteria.
I think what I need is to group the mySql statement differently but I'm unsure how to do this with the DataAssist Search recordset.
Any ideas?