?
Solved

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

Posted on 2004-04-03
2
Medium Priority
?
328 Views
Last Modified: 2006-11-17
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
Comment
Question by:Geerd
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
2 Comments
 
LVL 77

Accepted Solution

by:
peter57r earned 500 total points
ID: 10747239
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
 
LVL 1

Author Comment

by:Geerd
ID: 10747247
ThanX Pete
0

Featured Post

Veeam Disaster Recovery in Microsoft Azure

Veeam PN for Microsoft Azure is a FREE solution designed to simplify and automate the setup of a DR site in Microsoft Azure using lightweight software-defined networking. It reduces the complexity of VPN deployments and is designed for businesses of ALL sizes.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Microsoft Access is a place to store data within tables and represent this stored data using multiple database objects such as in form of macros, forms, reports, etc. After a MS Access database is created there is need to improve the performance and…
In this blog post, we’ll look at how using thread_statistics can cause high memory usage.
In this video, Percona Solution Engineer Dimitri Vanoverbeke discusses why you want to use at least three nodes in a database cluster. To discuss how Percona Consulting can help with your design and architecture needs for your database and infras…
In this video, Percona Director of Solution Engineering Jon Tobin discusses the function and features of Percona Server for MongoDB. How Percona can help Percona can help you determine if Percona Server for MongoDB is the right solution for …

770 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question