Finding a specific record using two fields

[leangross]

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.

 

[BruceHesher]

Have you tried using the member access operator "!"?

rstCus.MoveFirst
For loops = 1 to rstCus.recordcount
IF rstCus!LastName = mlname AND rst!FirstName = mfname THEN

... do something ...

rstCus.MoveNext
END IF
Next loops

 

[zemp]

The find method does not support multi-column searches. This page can give you more details.

http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnapg/html/apgapx02.asp

Your best bet is to incorporate your serach creiteria into your SQL statement.

Select * From table Where fisrtname='" & variable1 & "' and lastname='" & variable2 & "';" Thanks and Good Luck!

zemp