Migrating A2K to A2K2 - subform problems

[MacDermott]

I have an Access application I've used long and hard under A2K, but now I
need to run it on a PC which only has A2K2 installed.

One of the main forms has a subform, which is filtered when the form opens.
The filter occurs in the form's OnLoad event; it calls a sub (in the main
form's module), which (correctly) builds a criteria string named strWhere.
The next line of code looks like this:
Me!fsubWorkLog.Form.Filter=strWhere
This line throws an error, telling me that I'm referring to an object which
is closed or doesn't exist.
The immediate window returns False for
?Me!fsubWorkLog is Nothing
But when I type in
?Me.fsubWorkLog.Form is Nothing
I get the same error message about an object being closed or not existing.

Just as a precaution, I decompiled the code and ran it again, but the result
was the same.
Any ideas what could be going on?

TIA
= Turtle

[MacDermott]

sorry -
I tried to withdraw this when I found the problem, but it doesn't seem
to have "taken".

In case anybody cares,
the problem was that I hadn't re-linked the tables when I transferred
the application to another PC.
Once I got them pointed at an existing MDB, the problem went away.

- Turtle

"MacDermott" <ma********@nospam.com> wrote in message
news:ed*****************@newsread2.news.atl.earthl ink.net...

I have an Access application I've used long and hard under A2K, but now I
need to run it on a PC which only has A2K2 installed.

One of the main forms has a subform, which is filtered when the form opens. The filter occurs in the form's OnLoad event; it calls a sub (in the main
form's module), which (correctly) builds a criteria string named strWhere.
The next line of code looks like this:
Me!fsubWorkLog.Form.Filter=strWhere
This line throws an error, telling me that I'm referring to an object which is closed or doesn't exist.
The immediate window returns False for
?Me!fsubWorkLog is Nothing
But when I type in
?Me.fsubWorkLog.Form is Nothing
I get the same error message about an object being closed or not existing.

Just as a precaution, I decompiled the code and ran it again, but the result was the same.
Any ideas what could be going on?

TIA
= Turtle