ADODC recordsource

[ITfamily]

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

[LaVolpe]

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.

[ITfamily]

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.