Search in a table with "findfirst" method

[alinagoo]

Hi all & The best wishes for you

I want to search in a table with "findfirst" method upon tow variables,val and val2, but findfirst can not find any record with the match criteria and "NoMatch" property shows true when search become finished however the match record exists in the table!
this is the criteria expression:

SearchSTR = "[Pack_no]= ' " & val & " ' And [Item_no]= ' " & val2 & " ' "

Val is a string variable and Val2 is a numeric variable

Please help me

[missinglinq]

These things are always confusing to me, so I keep some exemplars. This should work if the info supplied is correct.

SearchSTR = "[Pack_no]= '" & Val & "' And [Item_no]= " & val2

Linq ;0)>

[alinagoo]

Great!
Thanks So.It worked correctly.
Who knows a complete reference to specify criteria strings in VBA?

[NeoPa]

Try Quotes (') and Double-Quotes (") - Where and When to use them.

[alinagoo]

Thanks So.Looks Good!
I'll read it.
Bye

[NeoPa]

I hope it helps you :)

Welcome to Bytes!