Howdy!

I need the syntax for a find statement with multiple criteria.

This works with one field, but I need 3 more fields.

strField = "Hello"
criteria = "Field1 = '" & strField & "'"

adoPrimaryRS.Find criteria, , adSearchForward, 1
If adoPrimaryRS.EOF = True Then Exit Sub

Thanx.

[Edited by hyme on 11-16-2000 at 11:06 AM]