forms don't show up in in VBE

[Ben]

Hi all,

I have a few forms that do not show up in the visual basic editor, when I
expand on the "Microsoft Offfice Access Class Objects". In particular, I
have a form that is based on a table and this form does not show up at all,
so that when I try to make reference to it in my code, VBE gives me error.
Any thoughts?

Thanks,

Ben



--

 

[Allen Browne]

If you open this form in design view, what do you have for its HasModule
property?

If you then click the module button on the toolbar/ribbon in the main Access
window, does this open the form's module for you?

 

[Ben]

Hi Allen,

That did it. It was the HasModule property. Didn't know this existed.
Thanks so much for your help!

Ben

 

[Allen Browne]

Great!

By way of explanation, a form that has no attached module (as shown by the
HasModule property) is called a lightweight form. These don't show up in the
VBE window because there is no attached class module to show.

Going in through the toolbar/ribbon in form design creates the module, and
then there is something to see in the VBE.