Use a variable to reference a command button

[zephyr]

I want to click a command button in code. In place of this: CommandButton1_click, I would like to use a variable like this: Variable_click. What is the syntax for this?

[jimatqsi]

You'll need more than syntax. You'll have to decide on an approach and code the various functions. You might try the Form's On_Click event. In that event you can test the name of the current object (what they clicked on) and then run the code appropriate to that object (Screen.ActiveControl).

Normally that would just be a lot more trouble than using each object's click event. But your situation may demand a more complicated soltution. Tell us more about what you are trying to accomplish. Perhaps there is a better approach.

Jim

[zephyr]

Looping thru a bunch of cmdbuttons and clicking each if a checkbox next to it is checked. I worked it out a diff way, like this:
'process all boxes
For Each Ctrl In form_mainform.Controls
If TypeName(Ctrl) = "CheckBox" And Ctrl.Name Like "*" & AA & "*" Then
If Ctrl.Value = -1 Then
theState = Mid(Ctrl.Name, 4, 2)
theCmd = "cmd" & theState

Select Case theCmd

Case "cmdaz"
form_mainform.cmdAZ_Click

Case "cmdde"
form_mainform.cmdDE_Click

Case "cmdfl"
form_mainform.cmdFL_Click
....
Instead of calling each button by name separately, I was trying to use something like: Form_MainForm.controls(theCmd)_click in the loop. But what I did works. Still open to suggestions though. Thx.