Unanswered: Building a Criteria for a Query from a form.
I have yet another question. This is the situation, we have three text boxes on a form. And we would like to create one query to pull data from these text boxes. The problem is that we need the query to be dynamic. Meaning when the program is running and the query is ran, sometimes only one textbox is used for the query. Other times all three or just two of the text boxes is used for the query. Is there way to build the criteria for that one query to select information from the desired textboxes and not just all three of them every time. For example it would be nice to coordinate it with an if statement.
If value = true then
Build the criteria to except data from one text box
Build the criteria to except data from two text boxes
It all boils down to this one simple question. Is it possible to build criteria for a query within a form’s code? Any help that anyone can give will be very much appreciated.