Findfirst with multiple criteria and like

[ozdemirozgur]

Hi,

I have two table and I need to find the records from the secodn table.I have the Coy_Id field common but need to find the Role fiels which includes ch in the field. I have the following code but does not work. please can you help?

/code
Do While Not Main10_2000_Combined.EOF
With EXTRAPPO07
.Index = "DUALKey"
EXTRAPPO07.FindFirst "Coy_Id " & "='" & Main10_2000_Combined!Coy_Id & "' AND " & _
"Role like" & "*ch*" & ""
/Code

thanks, Ozgur