ADODC recordsource

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

Welcome to the forums.

Try searching your entire project, not just the form, for: .RecordSource =
You may get more than one hit, so don't stop on the first hit.

Thanks for your suggestion, LaVolpe.
It turned out that the main problem was with the datagrid to which the adodc was the datasource. This had a limited set of fields showing. Once I had worked out how to edit the datagrid, I was able to find my new field.