Objects

C

Chris

Is there a Keyword that Identifies all of the Objects on a
Form. For Example. I want to know if all of the Radio
Buttons on a form are = True, Then, do Something?

-Chris
 
J

Jim Allensworth

Is there a Keyword that Identifies all of the Objects on a
Form. For Example. I want to know if all of the Radio
Buttons on a form are = True, Then, do Something?

-Chris
Click to expand...
You could use the form's Controls collection. Like ...

Dim ctl As Control
For Each ctl In Me.Controls
If ctl.ControlType = acOptionButton Then
If ctl = True Then
'Do something here
End If
End If
Next


- Jim
 
Top