problems with Find method in ADO

[Lol Owen]

Hi all, got a problem with the syntax for the Find method in an ADO recordset object. Assuming my recordset is called rsTrial and I want to find a field called Total where Total equals a variable, intTotal. I'm having problems getting the syntax straight. can someone sort me out please?

Cheers, Lol

 

[RoyVidar]

Assuming it is an integer, by the variable prefix

rs.movefirst ' need a current position
rsTrial.find "Total =" & intTotal
if not rs.eof then 
  ' you've found the record
end if

more info in the help topic for the Find method

 

[Lol Owen]

Cheers Roy, will give it a try!

Lol