I need some help with this problem as I've tried to resolve it for hours.
First let me startout by saying I am using access 2000.
What I am trying to do is to pass a string value from a combo box on a form to a Text box on a sub-form of that form. I have tried to create a class(consisting of let and get properties) and in-turn create an instance of that class on the sub-form to access its data. Here is where my frustration starts..... Everything seems like its going to work until I create an instance of the class on the sub-form, when I do this the intellesence does not recognize the object and I cannot create it. I noticed within my class the only 2 options I have for the Insaniating property of the class is 1-private, and 2-publicNotCreateable both are useless to me. I have done previous coding in Visual Basic(not for access) and the Insaniating property I use is 5-Multi-use.
How come this option is not available, Is it the version of VBA that I am using.
If anyone has any Ideas about where I should go from here it would be greatly appriciated.
Thanks,
Mike Oakes
First let me startout by saying I am using access 2000.
What I am trying to do is to pass a string value from a combo box on a form to a Text box on a sub-form of that form. I have tried to create a class(consisting of let and get properties) and in-turn create an instance of that class on the sub-form to access its data. Here is where my frustration starts..... Everything seems like its going to work until I create an instance of the class on the sub-form, when I do this the intellesence does not recognize the object and I cannot create it. I noticed within my class the only 2 options I have for the Insaniating property of the class is 1-private, and 2-publicNotCreateable both are useless to me. I have done previous coding in Visual Basic(not for access) and the Insaniating property I use is 5-Multi-use.
How come this option is not available, Is it the version of VBA that I am using.
If anyone has any Ideas about where I should go from here it would be greatly appriciated.

Thanks,
Mike Oakes