ADO equivilent to Set fld = rst.Fields(strFieldName)???

[jgoodman00]

dim fld as Field 'etc
Set fld = rsQdf.Fields(strFieldName)

Above is the syntax for setting the fld object to a specific field in DAO.

How is this done in using ADO? I have looked at the help file, but it only suggests enumerating through the entire collection of fields in a recordset, which I do not want to do. Instead I want to set the fld object to a specific object...


James Goodman

 

[cmmrfrds]

'- Value is default can be omitted
set fld = rsQdf.Fields("yourFieldNameinCollection&quot.Value

'- alternative
'- cnt = relative position of field in fields collection
set fld = rsQdf.Fields(cnt).Value