recordset.find

hey im trying to find in a db table a columns with a couple of criterias.. but does the find command allow more than one of them?
here's my code..

Code:

---

With rs_route
.Find ("stuid='" & stuid.Text & "' And bookid='" & bookid.Text & "' AND issuedate='" & dtp.Value & "'")
If .EOF = True Then
.AddNew

---

how do i get this working

FIND method only allow one criteria

You could execute a SELECT_FROM_WHERE query with 2 criterias over the connection
or
FILTER the recordset with the 2 criterias
or
FILTER on one criteria and use FIND with the other criteria

Moved to the Database Development forum.