Subform Visiblity Access 2003

[thepnut]

Hello all,

I'm currently using 4 subforms on a main form. The first form (FM_Staff)
shows a a list of staff names and review dates.

What I want to do is when you click on the name it make visible the 4th
subform (FM_rdc) and it displays the correct record (of the staff member
clicked on).

I can do it when I have FM_RDC as a stand alone form but can not seem to
call from one Sub form to an other.

 

[Jack Leach]

To hide the subform from the mainform, set the subform control visibility to
false.

So if you have a subform named Sub1 that is contained by a control named
Sub1Control, then you could use the following line in a click event...

Me.Sub1Control.Visible = Not Me.Sub1Control.Visible

.... to toggle the visibility of the control (and thus the subform) on and off


hth
--
Jack Leach
www.tristatemachine.com

"I haven''t failed, I''ve found ten thousand ways that don''t work."
-Thomas Edison (1847-1931)

 

[thepnut]

Thank you Jack.

To hide the subform from the mainform, set the subform control visibility to
false.

So if you have a subform named Sub1 that is contained by a control named
Sub1Control, then you could use the following line in a click event...

Me.Sub1Control.Visible = Not Me.Sub1Control.Visible

... to toggle the visibility of the control (and thus the subform) on and off


hth
--
Jack Leach
www.tristatemachine.com

"I haven''t failed, I''ve found ten thousand ways that don''t work."
-Thomas Edison (1847-1931)