Objects

[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

 

[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

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