Hi everyone,
I found some strange behaviour in a simple search form.
I have 5 checkboxes (step1, step2, step3, step4 and step5) and a button that calls an access query. This query takes values from the checkboxes to filter the results.
It is compulsory for being in some step (e.g. step3) to pass through all previous steps (step1, step2).
I build the query so that I need to check step1, step2, step3 if i want all the rows that have step3 = true. But this is not the problem.
The problem is that the only way I found to make the form behave correctly is to check, and uncheck all checkboxes before I check the ones I want to search for.
How can I correct that?
Thanks in advance
PS: Sorry if my english is not correct. Im not a native speaker.