Not sure if this is the right forum to post to but here goes:
I have a form which posts some values that are used in a query. Some of my form fields are checkboxes. If a box is checked then the query returns records where that box is checked, otherwise it returns all of the records for that checkbox (checked or unchecked). My problem is that if the user runs the query again and unchecks a previously checked box, the query returns records as if that box were still checked.
I tried setting a "triple-state" checkbox as described on another site but that did not work. I also tried creating a "reset form" button but no luck.
Any help is always appreciated.
Thanks in advance,