I have a dao.recordset which is made from a crosstab sql.
I want to know if a particular field name is one of the recordset's fields.
Is there a neat way of doing this without using onerror?
many thanks
Without trapping an error, which would be the quickest (realatively) and
shortest method, you'd have to cycle through the fields collection of
the recordset looking for the name of the field.
> I have a dao.recordset which is made from a crosstab sql.
> I want to know if a particular field name is one of the recordset's fields.
> Is there a neat way of doing this without using onerror?
>
> many thanks