Is there a way i can use the Find method in VB to find a specific record using two fields without using a query?
I tried using the "AND" but it produce an error.
with rstCustomer
.find "lastname ='" & mlname & "' and firstname = '" & mfname & "'"
if .eof then
.addnew
. . .....
.update
end if
end with
The error is
3001 Arguments are of the wrong type, are out of acceptable range, or are in conflict with one another.