Hide Controls Based on Check Box

[mcongdon]

This seems like it should be simple. I probably am neglecting to see something obvious, but I would like to have a checkbox that when checked will reveal controls. When unchecked, the controls disappear. I can't figure out what the VBA would be and I can't see any way to do it with Access 2000's macros. Any help would once again be greatly appreciated!

 

[straybullet]

AfterUpdate of the checkbox:

If Me.CheckboxName Then
Me.ControlName.Visible = True
Else
Me.ControlName.Visible = False
End If

Let them hate - so long as they fear... Lucius Accius

 

[TheAceMan1]

How are ya mcongdon . . .

Put a question mark [blue]?[/blue] (no quotations please) in the [blue]Tag[/blue] property of each control of interest. Then in the [blue]AfterUpdate[/blue] event of the checkbox, copy/paste the following:

[blue]   Dim ctl As Control
   
   For Each ctl In Me.Controls
      If ctl.Tag = "?" Then ctl = Me![purple][b][i]CheckboxName[/i][/b][/purple]
   Next[/blue]

[blue]Your Thoughts? . . .[/blue]

See Ya! . . . . . .

Be sure to see thread181-473997
Also faq181-2886