Command Button

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Is there a way to set a command button to run a different macro based on what
is selected in a option group.
 
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
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Add the command "Clear All Filters" to a Command Button in Access 2010? 0
Access Automatically Send a notification email once a record is added 0
Toggle button vs Command button 2
Command button action 3
Do I need an option group? 8
Command Button not working 1
How to Edit the Macro that exists behind an existing Command Butto 2
option group and command button 2

Back
Top