Hi,

In code i have opened a record and from this recordset i want to select a particular record. To find this record I need to give two criteria’s, one is a product code and the other is an issue number (Both of these fields are numeric).

So far I am able to specify only one criteria:

myset.findfirst "ProductCode = '" & txtproductcode & "'"

How do I specify both of them at the same time? (I don’t want to use a query!)

Thanks

Try....

myset.findfirst "ProductCode = '" & txtproductcode & "'"
& " AND " & "IssuseNumber= '" & txtIssueNumber & "'"

HTH