Simple VBA question: Making a subform visible using a Case select in a Module
Posted on 2004-04-03
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.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
Any help is welcome!