Hi,

I use rst.Find to find records, but need to use the like operator.
And I need to use parameters for the fieldnames and searchstrings.
Anybody can give me a working example?

This doesn't work:

strFiendField = "CNR"
strSearchString = 100

varReturn = rsCustomer.Find(strFindField & " = " & Trim(strSearchString), , adSearchForward)

varReturn = rsCustomer.Find(strFindField & " LIKE " & Trim(strSearchString), , adSearchForward)


Franky