Howdy!

OK.. Here's one I've never tried!

Using the FIND Statement with 1 field works fine, but can you it to find 2 Fields????


This works:

Lastname = "DOE"
Criteria = "Last_Name = '" & Lastname & "'"
adoPrimaryRS.MoveFirst
adoPrimaryRS.Find Criteria, , adSearchForward, 1

This doesn't:

Lastname = "DOE"
FirstName = "JOHN"
Criteria = "Last_Name = '" & Lastname & "'" & " AND First_Name = '" & FirstName & "'"
adoPrimaryRS.MoveFirst
adoPrimaryRS.Find Criteria, , adSearchForward, 1

HELP!!!!! Thanx!