I know you can set a filter to 'adFilterPendingRecords' which is similiar to GETNEXTMODIFIED(). They only way i know of determining which fields have changed is comparing the field(x).Value with the field(x).OriginalValue.
Hope this helps
Geno
>I want to check for changes made by the user when using ADO.
>If VFP, I can call getfldstate on a cursor to see if
>it has fields that have changed. Is there an equivalent for ADO
>recordsets? I am using ADO with VB in this case.
>
>Thanks,
>Dave Mihalik
>
dmihalik@stansleygroup.com