I'm still failing at simply looping through all the controls on my form
When you are using controls in a Form then you need to try this...

vb Code:
  1. Private Sub CommandButton1_Click()
  2.     Dim ctl As Control
  3.     For Each ctl In Me.Controls
  4.         If TypeName(ctl) = "OptionButton" Then
  5.             MsgBox ctl.Name
  6.         ElseIf TypeName(ctl) = "CommandButton" Then
  7.             MsgBox ctl.Name
  8.         ElseIf TypeName(ctl) = "Frame" Then
  9.             MsgBox ctl.Name
  10.         End If
  11.     Next
  12. End Sub