Is it possible to use a boolean expression in the criteria of the .Find method on an ADO recordset?
rs.find "Purchaser = 'Acme' AND InvoiceNo = 'X34FF'",,adSearchForward
(this results in syntax error 3001 - argument of the wrong type blah blah blah)
I also tried:
rs.find "Purchaser & InvoiceNo = 'AcmeX34FF'",,adSearchForward
Maybe it can't be done??