Finding references to another form

  • Thread starter Thread starter BobRoyAce
  • Start date Start date
B

BobRoyAce

When I was opening FormA, it was asking me for a parameter (e.g.
Forms!FormB!txtField1). When I searched the Data tab properties for FormA, I
noticed that it had a Filter property that was referencing the
Forms!FormB!txtField1. So I removed it and replaced it. Now, for some
reason, when I open FormA, it still prompts for that parameter even though I
can't see any other control/property that references it. I have looked in
the code behind the form (esp. OnLoad event code, etc) and I do not see any
references to it there either. Is there an easy way to find out what is
referencing it still and where?
 
Bob,

Also check out the RowSource property for combo boxes and listboxes, and if
the form is based on a query, check that too.

The reference could literally be anywhere. As a last resort, you can check
the ControlSource of all the textboxes.

Regards,
Graham R Seach
Microsoft Access MVP
Sydney, Australia
 
Back
Top