Closing a form in an opened database from a different database

[GeorgeMar]

I have a database A (say) that opens database B (say). Both remain open.
Database A has a hidden form opened. I want to close the form from with
database B.

If I use .OpenCurrentDatabase, it creates a NEW instance. I presume that I
want to simply use the opened database without creating a new instance.

What is the best approach?

many thanks
george

 

[Douglas J. Steele]

Presumably you're using .OpenCurrentDatabase against an instance of the
Access Application object. How are you instantiating that instance? This is
one of the cases where you need to use GetObject, referring to the instance
that's already running.

 

[GeorgeMar]

Thank you Doug again. It worked a treat!

Presumably you're using .OpenCurrentDatabase against an instance of the
Access Application object. How are you instantiating that instance? This is
one of the cases where you need to use GetObject, referring to the instance
that's already running.