• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 332
  • Last Modified:

Simple VBA question: Making a subform visible using a Case select in a Module

Hello Everyody,

I got a form called frmMain. In that form there is a subform called frmDatum_Overzicht.
The subform is set to be invisible.

When a user enters data a count is made that is used in a Case Select structure in a Module.

I want tot make the subform frmDatum_Overzicht visible if the Case is 2 of 3.
In the Case = 2 block I got the following code.

        Forms!frmDatum_Overzicht.Requery
        Forms!frmDatum_Overzicht.Visible = True

When I run the above option I get the message "access can't find the form frmDatum_Overzicht".

I think Access can't find the form because it is a subform of frmMain. But I don't know how to program
that.

Any help is welcome!

ThanX
0
Geerd
Asked:
Geerd
1 Solution
 
peter57rCommented:
Hello Geerd,

> Forms!frmDatum_Overzicht.Requery
>         Forms!frmDatum_Overzicht.Visible = True


Forms!frmMain!frmDatum_Overzicht.Form.requery
Forms!frmMain!frmDatum_Overzicht.visible = true


Pete
0
 
GeerdAuthor Commented:
ThanX Pete
0

Featured Post

Free Tool: Path Explorer

An intuitive utility to help find the CSS path to UI elements on a webpage. These paths are used frequently in a variety of front-end development and QA automation tasks.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now