Why this sql RecordSource not working?

[zx3]

Hi all,
I have this table named inv

ID code qty
1 [1[2[26
2[1[3[29
3[1[4[ 33
4[1[5[ 28
5[1[6[ 30
6 [1[7[ 18


7 [1[8[ 20
8 [1[9[ 9

and i use this code to put the 2 records on a form
nostr = "[2[8[1[8[1[7["
Me.RecordSource = "SELECT * FROM inv WHERE ((InStr('" & nostr & "', qty)) > 0);"

The only 2 records should show are with ID 6 and 7 because only they have the code that found in nostr, but nothing show up, any idea?

Here's the db if you want to try it out, thanks.

[rpeare]

    Me.RecordSource = "SELECT * FROM inv WHERE ((InStr('" & nostr & "', qty)) > 0);"

this is your existing statement in the ON CLICK event of your button

you're checking a numeric value (quantity) against a string, that will always fail.

you want this:

    Me.RecordSource = "SELECT * FROM inv WHERE ((InStr('" & nostr & "', code)) > 0);"

[RuralGuy]

From VBA Help:

InStr([start, ]string1, string2[, compare])
string1 Required. String expression being searched.
string2 Required. String expression sought.

I believe you also have your string references reversed.

[zx3]

    Me.RecordSource = "SELECT * FROM inv WHERE ((InStr('" & nostr & "', qty)) > 0);"

this is your existing statement in the ON CLICK event of your button

you're checking a numeric value (quantity) against a string, that will always fail.

you want this:

    Me.RecordSource = "SELECT * FROM inv WHERE ((InStr('" & nostr & "', code)) > 0);"

Thanks rpeare, i double checked my code, yeah it should be code instead of qty in the sql recordsource string. Thanks for all the time for helping.