Finding references to another form

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?
 
G

Graham R Seach

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top