I'm using a front end, a middle, and a back end in Access
2002.
I want the front end, containing my forms, to use a class
module contained in a different database, the middle.
I have added a reference to the middle in the
Tools/References of the front end. Worked fine.
But, I can't use the class, it simply doesn't seem to
recognise it.
On my form in the front end, I wan to have (in general
declarations);
Dim myClass as clsFromMiddle
Then on Form_Activate I want to have;
Set myClass = new clsFromMiddle
But I type "Dim myClass as " and the reference to the
class in the middle db doesn't exist in my drop list,
therefore I can't use it.
How can I overcome this?
Thanks so much.
John
