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

In addition to the way Erick suggests, you could do this:

FOR EACH loControl IN ThisForm.Controls
   lcCS = loControl.ControlSource  && or whatever
ENDfor