I have a form with several unbound search fields and code that I got from a gracious helper that creates SQL search phrase from those unbound fields. The filterOn works when I click the cmd_Search and I get exactly what I want as a search result... BUT when I place a cmd_Clear_Search_Terms and click to blank out the 3 search fields it does not work. Some fix I tried blanked out the fields but if I re-click on the cmd_Search btn then the query brings up whatever the last search brought up. The first time that I click on cmd_Search with no terms in the unbound boxes I have a msgbox that popsup a "no criteria" message just like it should. Why do you think that by trying to clear out the terms that I get the same results.
It's like whatever I do I can't get the search fields to blank out and the cmd_Search btn to reset, but get the earlier search term results.
Any one have any time to drop a hint to a struggling amateur?
Thanx