Hiding Subforms

[Sandman007]

When a certain value is set to true, I would like to hide a subform in my main form.

When using the following code:
[Forms]![Customer Information].[Usage Based Aggregate subform].hide

I get the following error:
Object doesn't support this property or method

Can anyone suggest different code to hide a subform within a form?

 

[jgoodman00]

In the after_update event of the control you wish to trigger the visible/invisible property include the following code:

If me.txtControl = True Then
me.SubformName.Visible = False
Else
me.SubformName.Visible = True
End If


James Goodman

 

[jebry]

Hi!

You can make the subform control invisible:

[Forms]![Customer Information]![YourSubformControl].Visible = False

Note that, in the third set of brackets, you will need the name of the subform control, not the name of the subform itself.

hth

Jeff Bridgham
bridgham@purdue.edu