Find method not working - Access 2000 ADO

[chansen]

I'm trying to do a simple find method in an ADO recordset, and can't get it to work for the life of me.

The Access help file shows a Find Method for specific text in modules and class modules, but not the ADO Find Method?

The following code generates, "Run-time error '3001' - Args. are of wrong type, out of acceptable range, or in conflict with one another"

Dim intCatSortA As Integer
Dim rs As New ADODB.Recordset
rs.Open "SELECT * FROM tblEstCategories " & _
"ORDER BY CatSort", CurrentProject.Connection, _
adOpenKeyset, adLockOptimistic
intCatSortA = Me!lstCategories.Column(2, Me!lstCategories.ItemsSelected)
If intCatSortA <> 0 Then
rs.Find &quot;CatSort = intCatSortA&quot; <- hangs here
etc.

What is going wrong with the help system and my code?

Somebody?

Anybody?

Thanks,
Craig

 

[BlackKnight]

Hi,

Since 'intCatSortA' is a variable you don't want the word 'intCatSortA' as your criteria but its integer value.

Try this:

rs.Find &quot;[CatSort] = &quot; & intCatSortA

 

[chansen]

I could kiss you.

Now, why does &quot;Help&quot; not display help for this method, or many other ADO and DAO methods?

Craig