How do I create cascading forms?

[foxy]

Hi,

I have a form that has unbound text boxes on it.

How can I hide a section of the form until the user checks a box? When the user checks a box I want the hidden text boxes to appear, much like a cascading web form.

Cheers

 

[JANR]

You can use some VBA to do this, In the After_Update event of your checkbox you can put something like this:

Private sub chkbox_After_Update()
  If (Me.chkbox = True) Then
    Me.txtbox1.Visible = True
    Me.txtbox1.Visible = True
    .. etc
  End If
End Sub

JR

 

[foxy]

Thanks very much for that mate, thats really helpful.

Is there anyway to make a section of the form collapsible and expandable on the update of the checkbox? A bit like the example in the link below. I know this is AJAX but I wonder if there is a way to mimic this in access?

http://www.asp.net/AJAX/AjaxControlToolkit/Samples/CollapsiblePanel/CollapsiblePanel.aspx

Cheers

 

[JANR]

Maybe this is something you are looking for:

http://www.lebans.com/cangrow.htm

JR

 

[foxy]

Thats sort of the thing yea, but that only allows a particular text box to expand depending on what is stored in it. I actually want a whole section of the form to appear and dissapear on the click of a check box.