Quickest way to find a specific record

[JR Ewing]

I've been using DAO and it's FindFirst method, but when I started using ADO I've had many problems with its Find method.

For example rs.Find("reckey = '0153'") I always get the error "Rowset does not support scrolling backward."
I've tried adOpenDynamic, adOpenForwardOnly, adOpenKeyset and adOpenStatic and still get the error

But if I use adOpenDynamic and rs.Find("reckey = '0153' AND rectype = 'IU'") I get the error "Arguments are of the wrong type, are out of acceptable range, or are in conflict with one another." I know that the reckey is set up as a Char(8) and rectype is Char(2).

Can anybody see something that I can't? Am I using the Find method correctly? Is there a better way searching for a record using ADO?

Try using SQL

eg

Dim sSQL
sSQL = " SELECT * FROM Tablename WHERE Field = 'Data' "

I know that in DAO you go:

Set RS = DB.openrecordset(sSQL)

But I cant remember for ADO