xollef
Technical User
- Apr 23, 2002
- 30
Hey.
I have a form that has 5 textboxfields on it which gives the criteries to a Query. The query is after that inserted to the form as a subform so that you can see the results of the query on the form after you update it.
So now my question is that when I have 5 fields for different crieteries for the query I wan't to be able to choose if they are OR or AND criteries.
Lets say after the 5 fields there could be 2 radio buttons and you could choose the option on the form itself that it would be one or the other.
Like:
And OR
First Name: o o
Last Name: o o
Gender: o o
Age: o o
Nationality: o o
But how do I create the query to be able to know the difference based on the radio buttons?
I have a form that has 5 textboxfields on it which gives the criteries to a Query. The query is after that inserted to the form as a subform so that you can see the results of the query on the form after you update it.
So now my question is that when I have 5 fields for different crieteries for the query I wan't to be able to choose if they are OR or AND criteries.
Lets say after the 5 fields there could be 2 radio buttons and you could choose the option on the form itself that it would be one or the other.
Like:
And OR
First Name: o o
Last Name: o o
Gender: o o
Age: o o
Nationality: o o
But how do I create the query to be able to know the difference based on the radio buttons?
