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
 
You must log in or register to reply here.

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

Similar Threads

modal options. my form open behind the form. 2
form access 1
Determine if form is open 3
Tab control issue (Access 2000 vs 2003?) 2
Trouble w/ OpenArgs 4
Save form data on change of focus 5
how to save the form record with vba outside of the form 6
referring to a text box on a subform from another form. 2

Back
Top