ADO find

[cfriedberg]

I want to find a record whose field name is contained in array element pFieldNames(0, 0) and the value of the field is contained in pFieldNames(0, 1).

In this case the value of pFieldNames(0, 0) is "Emp #"

How do I represent this using the criteria that is set out by ADO?

Carolyn

 

[cfriedberg]

I got my own answer.

rs.Find pFieldNames(0, 0) & " = " & pFieldNames(0, 1)

To me, the confusing thing is that Find requires a string.

Carolyn