I'm using Allen Browne's search form in an application for demographic purposes.
The form is working fine, but the user is asking for a new functionality. He wants at lease 3 state combo boxes so he can filter that [State] field for at lease three choices and the way it is build now he can only have one. I tried the following code (with the corresponding text boxes in the form), but it didn't, the result was no search at all.
In the Allen Browne's documentation he explains about using the AND and OR's and I tried a few combinations, but the result this time was no record found at all.
Any ideas?
-West
The form is working fine, but the user is asking for a new functionality. He wants at lease 3 state combo boxes so he can filter that [State] field for at lease three choices and the way it is build now he can only have one. I tried the following code (with the corresponding text boxes in the form), but it didn't, the result was no search at all.
Code:
If Not IsNull(Me.txtState01) Then
strWhere = strWhere & "([State] Like ""*" & Me.txtState01 & "*"") AND "
End If
If Not IsNull(Me.txtState02) Then
strWhere = strWhere & "([State] Like ""*" & Me.txtState02 & "*"") AND "
End If
If Not IsNull(Me.txtState03) Then
strWhere = strWhere & "([State] Like ""*" & Me.txtState03 & "*"") AND "
End IfAny ideas?
-West
