-
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
-
Re: recordset.find
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
-
Re: recordset.find
Moved to the Database Development forum.