check box for visable??

[CEH]

Well, same question as before..... property on form set to visable = false
I do not see any property for a check box... checked to display subform... uncheck to be invisable....
Quick answer for that one??

Thanks so much

 

[trucktime]

Form

In the On Current Event of the form:

If Me.Checkbox = True Then
Me.subform.visible = True
Else
Me.subform.visible = False
End If

 

[CEH]

Thanks again

Thanks again......
I'm doing some classes on Access...... Macros and VBA comes up Monday..... I get ahead of myself.......But "what the hey......"

 

[trucktime]

Great

No problem, and good luck with the classes.

 

[trucktime]

Hide

Try this:

Private Sub Check61_Click()
If Me.Check61 = True Then
Me.123.visible = True
Else
Me.123.visible = False
End If
End Sub

Instead of making the button visible or invisible you
may want to enable or disable it.
That way the user will know at any time there is a button to execute
an action:

Private Sub Check61_Click()
If Me.Check61 = True Then
Me.123.enabled = True
Else
Me.123.enabled = False
End If
End Sub

It is also good practice to use meaningful names,
so instead of 'Check61' something like: 'CheckOnOfButton123'.
When the program grows it will will be easier to find the right
code in case you need to modify or debug it.

 

[blower16]

Thanks alot - really happy ive found a place that can answer like this

 

[trucktime]

Great

You're welcome, and Good Luck.