G Guest Jan 3, 2006 #1 Is there a way to set a command button to run a different macro based on what is selected in a option group.
Is there a way to set a command button to run a different macro based on what is selected in a option group.
G Guest Jan 3, 2006 #2 On the OnClick event of the button you can write the code Select Case Me.OptionGroupName Case 1 docmd.RunMacro "Macro1Name" Case 2 docmd.RunMacro "Macro2Name" Case Else docmd.RunMacro "Macro3Name" End Select
On the OnClick event of the button you can write the code Select Case Me.OptionGroupName Case 1 docmd.RunMacro "Macro1Name" Case 2 docmd.RunMacro "Macro2Name" Case Else docmd.RunMacro "Macro3Name" End Select
