Show/Hide Subform...fidsgal

  • Thread starter Thread starter fidsgal
  • Start date Start date
F

fidsgal

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!!

--Amy
 
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.
The subform control is a control that holds the subform. You will need to
refer to the name of this control in your code. (example:
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.
 
Back
Top