VB Editor causes an error. And why does a form have a Report in it?

[acotgreave]

Hi,
I've inherited a database for a company I do support work for, and it
has a problem with its database that I don't understand.

When I copy the day's copy of the database onto my laptop it works fine
on my laptop.

The problem is, I then do the following:
1. Open the VB editor (Alt+F11). At this stage, that's ALL I do. I
don't change a thing
2. Return to the database. Click on one of the buttons to show company
details (this is normal usage)
3. I now get run-time error 2467 ("The expression you entered refers to
an object that is closed or doesn't exist") on the following line:

Set rs = FinForm!FinancialsSubform_Accounts.Report.Recordset

The question, then, is WHY do I get an error on this line after doing
nothing more than opening the VB Editor?

And secondly, I don't understand how or why a subfom has its own Report
- I thought Reports was just an application-wide collection.

The above line DOES work if I don't open the VB editor...

I'm running Access 2003, v11.6566.6568 SP2 (on Windows XP SP2)

Thanks for help in advance,

Andy

 

[JoeCruse]

While you are in the Editor, check for missing or broken references.