I'm using Access 2007.   I have several forms that are not listed in the 
"Microsoft Office Access Class Object" list.   I've searched on-line help to 
no avail.

How can I add it?

Your help will be greatly appreciated!

I'm usually a pretty good mind reader but you seem to be out of range.

Do you think you could provide us with your code that isn't working for you, 
a brief explanation of what you need it to do and then we will be able to 
help.
-- 
Hope this helps,

Daniel Pineault
http://www.cardaconsultants.com/
For Access Tips and Examples: http://www.devhut.net
Please rate this post using the vote buttons if it was helpful.



"laavista" wrote:

> I'm using Access 2007.   I have several forms that are not listed in the 
> "Microsoft Office Access Class Object" list.   I've searched on-line help to 
> no avail.
> 
> How can I add it?
> 
> Your help will be greatly appreciated!

I have no code at this point. I've created 5 forms. 3 of the forms are listed 
in the "Microsoft Office Access Class Object" list which will allow me to add 
code. 2 of the forms are not listed. I did rename one of the unlisted, but I 
did check the "form name" in properties, and it had the correct name.

Thanks in advance for any help you can provide.

"laavista" <laavista@discussions.microsoft.com> wrote in message 
news:D151EE5F-682A-4B72-B12D-9B4C92FFA5FE@microsoft.com...
> I'm using Access 2007.   I have several forms that are not listed in the
> "Microsoft Office Access Class Object" list.   I've searched on-line help 
> to
> no avail.
>
> How can I add it?
>
> Your help will be greatly appreciated!

Forms and reports only appear in the VBE's class object list if they have an 
attached module. Not sure how to ensure this in A2007 because I don't have 
that version, but in A2003 at least you would click on the 'View' menu and 
select 'Code'. IOW as soon as you add some code to a form's module it will 
appear in the list.

Thanks for taking the time to help with this!

"Stuart McCall" wrote:

> "laavista" <laavista@discussions.microsoft.com> wrote in message 
> news:D151EE5F-682A-4B72-B12D-9B4C92FFA5FE@microsoft.com...
> > I'm using Access 2007.   I have several forms that are not listed in the
> > "Microsoft Office Access Class Object" list.   I've searched on-line help 
> > to
> > no avail.
> >
> > How can I add it?
> >
> > Your help will be greatly appreciated!
> 
> Forms and reports only appear in the VBE's class object list if they have an 
> attached module. Not sure how to ensure this in A2007 because I don't have 
> that version, but in A2003 at least you would click on the 'View' menu and 
> select 'Code'. IOW as soon as you add some code to a form's module it will 
> appear in the list.
> 
> 
> .
>