View Single Post
  #3 (permalink)  
Old March 7th, 2004, 05:01 PM
Steven Steven is offline
Friend of Wrox
Join Date: Jun 2003
Location: Melbourne, Vic, Australia.
Posts: 308
Thanks: 0
Thanked 0 Times in 0 Posts

If you've got a whole heap of options, it might be best to steer clear of a massively nested IF statement, an use Case Select statements. eg:
Select Case Me.OptionGroup
     Case 1
       'Do Something
     Case 2
       'Do Something Else
     Case 3
       'Do Something Else again
'Keep adding as many cases as needed
     Case Else
       'Nothing was selected
End Select

I am a loud man with a very large hat. This means I am in charge
Reply With Quote