Hi
I have an unbound text box that I'm using as a search box to filter the records on my form and appears to work well however can only get it to apply to text box fields on the form using the expression below
I have a field called "Location" which is a combo box however simply replacing "Serial Number" with "Location" in the above code doesn't work.
I want to keep this as an unbound text filter search box.
Can anyone enlighten me?
I have an unbound text box that I'm using as a search box to filter the records on my form and appears to work well however can only get it to apply to text box fields on the form using the expression below
Code:
[TempVars]![strFilter] & " OR ([Serial Number] Like ""*" & [TempVars]![strSearch] & "*"")"I have a field called "Location" which is a combo box however simply replacing "Serial Number" with "Location" in the above code doesn't work.
I want to keep this as an unbound text filter search box.
Can anyone enlighten me?
