Subform Visiblity Access 2003

  • Thread starter Thread starter thepnut
  • Start date Start date
T

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.
 
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)
 
Thank you Jack.



Jack Leach said:
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)
Click to expand...
 
Back
Top