Filter a record on a continuous form

[neelsfer]

I have an unbound txtbox at the top of a continuous form, to filter records below that could be in any of two fields - "ICN" or MICN"
If i add the item code to the txtbox , then it must look at both. I use the "onchange event"

Me.Refresh
    ''strFilter = "icn like '*" & Me.findCode & "*'"  ' this works 100% for 1 field only
 strFilter = "icn like '*" & Me.findCode & "*'" Or "micn like '*" & Me.findCode & "*'"
 
    Me.Form.Filter = strFilter
    Me.Form.FilterOn = True
    Me.findCode.SelStart = Nz(Len(Me.findCode), 0)

It has to do with the "strfilter" row. Please assist.

[zmbd]

Neelsfar,
You've really provided very little information to work with, such as Access version, the data types, EXACT error message (title, number, and text) you are (or if you are not) receiving. The desired results and what is actually happening.

However, as a stab in the dark please try two things:
Please do the following:
Read thru the following link: set the option explicit and do the basic trouble shooting and compile as given in the first few parts.

While you are doing this, also insert right after line3 in the code block:

debug.print "Your criteria = " & strFilter

Run your code, press <Ctrl><G> to open the immediate window. You will see the result of your string in this the window. Review it for correct format. Copy and paste it back here if you don't see the issue

> Troubleshooting and posting (VBA or SQL) Code

[Seth Schrock]

The problem (at least one of them) is that the "OR" isn't included in the double quotes so it isn't being part of the string.

 strFilter = "icn like '*" & Me.findCode & "*' Or micn like '*" & Me.findCode & "*'"

You would have certainly discovered this using Z's instructions. Please still follow them to make sure that the string does in fact concatenate like you expect.

[zmbd]

One of the issues; however, having the resolved string from the debug print will help to point out any others.

[neelsfer]

Thx zmbd for suggestion i was away the whole day and got back now only.Will do it next time. Zeth you are spot on - 1 works! thx