recordset usage in visual basic

how we could check for more than two or
three conditions while using rs.findfirst method
Who is Participating?
TimCotteeConnect With a Mentor Commented:
Dim strCriteria as String

strCriteria = "[Field1] = 'Value' AND [Field2] = 3 AND [Field3] > 400"

* OR *

strCriteria = "[ShipCountry] = 'UK' And [OrderDate] >= #1-1-95#"
rs.FindFirst strCriteria

Should do it.
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.