Hi,

I am modifying someone else's old form, which uses a adodc, and I need to change one of the fields in its recordset. The recordsource appears to be set just once in the code, and I have recoded the SQL to pick up the fields I want. However, each time the form loads, the recordsource appears to have lost the field I am interested in. Have not used these adodcs before, so I am wondering if anyone has any tips about how it might be getting reset.
Thanks

A