Hi,

Is there a generic way I can loop through the form controls and check their control source property?

For e.g I can loop through the fields in a table by doing the following

For nctr = 1 to FCount()
* can take any required action I want
EndFor

Similarly can I do this for form controls. I want to determine if the control source is "X" then change the back color of the control to "yellow". I need to do this when the form loads because the control can vary each time.

Thank you.
Neetu Kumar