Unbound search box ... Search using LIKE and OR gives me my message box error

[MarksinMO]

I have a command button with the code below ... Individually each code get my expected results ... I was trying to combine the two into one using OR ... my end result is the MsgBox error. It's not seeing anything in the unbound text75 box.



I'm sure this is a missing or extra - quote, apostrophe or parenthesis !!! ... I have tried many different combination and have not hit on the correct combination. Or am I missing something else? Thanks in advance.

Option Compare Database


Private Sub Command74_Click()
On Error GoTo Command74_Click_Err


'This Works Fine DoCmd.ApplyFilter , "[ID]= " & [Forms]![PrintSelect]![Text75] & ""
'This Works Fine DoCmd.ApplyFilter "", "[Owner] Like ""*"" & [Forms]![PrintSelect]![Text75] & ""*"""

The Following Does Not work
DoCmd.ApplyFilter "", "[ID] = " & [Forms]![PrintSelect]![Text75] & " Or [Owner] Like ""*"" & [Forms]![PrintSelect]![Text75] & ""*"", """



Command74_Click_Exit:
Exit Sub


Command74_Click_Err:
MsgBox "Enter Criteria in Search Box"
Resume Command74_Click_Exit


End Sub

[June7]

I've never used ApplyFilter. I use:

Me.Filter = "[ID] = " & [Forms]![PrintSelect]![Text75] & " Or [Owner] Like '*" & [Forms]![PrintSelect]![Text75] & "*'"
Me.FilterOn = True

If you have an ID to search for, why would you need the Owner criteria?

Is ID a number field? Is the value of Text75 a number? Why would you also use a number to search Owner field? LIKE operator and wildcard only works with text values.

[MarksinMO]

If I search ID there are no issues however your code brings up the box below ONE time - the first time I search "LIKE", after I ack OK then it will search for either criteria multiple times with no issues. Close the form and reopen it does the same thing with the text search the first time.





ID is the PK autonumber ... Owner is the generator would need this for reporting purposes ... ID would search for number so = to, Like to search for "like" texts

[June7]

What is 'ter' - I don't have 'ter' in my suggestion.

What is Text75 - an UNBOUND textbox where user can enter anything for search parameter? If user enters text like "John Doe" the ID criteria will error.

Need to dynamically build the filter string. Review http://www.allenbrowne.com/ser-62.html

[MarksinMO]

Yes Unbound text box as stated above ... ter is the first three letters for Terry ... an owner of numerous records in the Db ... for the most part the user will enter three to four letters to search for the owners name ... I entered ter in the unbound text75 and the first time it pops up the enter parameter value ... I click OK (I don't have to enter anything) once and it brings up all records that has any form of ter in the field. Terry Waters Carter, etc. Once I click OK the first time I can search for any letter combination with no issues. If i close and reopen the same issue occurs.

Thanks

[June7]

ID is a number type field. Entering a text value as parameter should cause data type mismatch. Perhaps the popup is related to this issue.

My point is, cannot have this filter criteria constructed like this. These are two different kinds of fields and they cannot have the same parameter.

Did you review the referenced link?

You could have conditional code like:

If IsNumeric(Me.Text75) Then
strWHERE = "[ID] = " & Me.Text75
Else
strWHERE = "[Owner] Like '*" & Me.Text75 & "*'"
End If

[MarksinMO]

Ok thanks ... I looked over AB's code and will look to see if I can make sense of it and apply it to my Db ... I have used suggestions from AB several times.