Find method

[erez_zi]

Hi,
When using the Find method with a recordset, is it possible to have 2 terms in the criteria string? Example:

rst.Find "ID = 5 AND subID = 17"




Thanks in advance
Erez

[Cakkie]

ADO does not allow multiple search arguments when using the Find method. The filter property however does support multiple criteria.

rst.filter = "ID = 5 AND subID = 17"




Tom Cannaerts
[email protected]

Programming today is a race between software engineers striving to build bigger and better idiot-proof programs, and the universe trying to produce bigger and better idiots. So far, the universe is winning -- Rich Cook