| | |
|
|
|
Show/Hide Subform...fidsgal |
|---|
| message from fidsgal on 5 May 2004 |
I have a main form and a subform that are linked. On the main form, I
have several check boxes with text. My goal: As a user clicks on a
check box, I want the form associated with that text (subform) to "pop
up". The user may check as many as needed, likewise the same number
of forms needs to pop up. It appears that I will need about 10
subforms (10 associated check boxes). Is it possible to have that
many subforms and if so, what properties do I set to make the forms
pop up? I've tried several different settings and still cannot get
the desired results. All help is greatly appreciated!!
|
| Wayne Morgan replied to fidsgal on 5 May 2004 |
In the AfterUpdate event of each checkbox and possibly in the form's Current
event (to get the value of the checkboxes as you move from one record to
another) you will need to set the Visible property of the subform control.
Me.subform1.Visible = False).
From the help file, "A main form can have any number of subforms if you
place each subform on the main form. You can also nest up to seven levels of
subforms." However, adding subforms will slow down the loading of the main
form, how much depends on what you're doing. You'll need to test and see if
it is acceptable to you.
|
|
Archived message: Show/Hide Subform...fidsgal (MS Access Database)
