New Access Form Not Showing Up In VBE Collection of Forms

[AlexB123]

Hi all,

I am adding a new form to a pre-existing split - database. However, when I open up the VBE, I can't find it. I'm certain this is a pretty simple issue, but I can't find anything similar searching online.

Any ideas?

Thanks,

 

[ranman256]

So you open the form and it does not snow in the FORMS collection?
but you can open it with Docmd.openform?
then who cares? Just use openform.

 

[stumac]

It will show up after you add code to it.

 

[AlexB123]

Well, I need to add code to it for it to be of any use whatsoever.

I did create a module ...

Private Sub CheckForm()
    DoCmd.OpenForm "frmAdmin"
End Sub

It does open my form, but the frmAdmin does not show up in the forms collection. I would like to add the code I have written.

 

[AlexB123]

It will show up after you add code to it.

But I can't add the code?

 

[xenou]

With the form in Design view, click the view code button (gets a little wierd explaining the ribbon menus but it's basically a part of the form design tools ribbon, tools section, which is a context driven menu that shows up when you are view a form in design view).

In short, forms don't always have code modules at first.

You can also search for the HasModule properties in the form properties and set it to true.

You could also probably click on one of the form events to auto-generate a code stub for some event (like the On_Load event), which would create a module for the form automatically as well.

Private Sub CheckForm()
DoCmd.OpenForm "frmAdmin"
End Sub

note that you created a standard code module, not a code module for the form.

 

[AlexB123]

You can also search for the HasModule properties in the form properties and set it to true.

That did it!!! Many thanks! I never would have found it!