Multiple command buttons

[Gmoz]

Was woundering if the was a way to habdle multiple command buttons with one procedure. I have done a little VB.Net and I remember that you coud use one sub to handle multiple buttons using the handles key word. I was wondering if Access could do that. What I have is 37 command buttons named cmdView1 through cmdView37 all I really need is the number that prefixes the command buttons name. I know how to pull out the number but I can not figure out how to use only one sub procedure for all 37 buttons. Any help is appreciated.

Frank

 

[epicmove]

try this.......

Function UseForAllButtons ()
'put your code here to get button number
'you may need to define a button variable i.e. dim ctl as control
'ctl.controltype = acCommandButton
End Sub

Private Sub CmdButton1_Click()
Call UseForAllButtons
End Sub
Private Sub CmdButton2_Click()
Call UseForAllButtons
End Sub
Private Sub CmdButton3_Click()
Call UseForAllButtons
End Sub
Private Sub CmdButton4_Click()
Call UseForAllButtons
End Sub
'.................. 'and so forth
'..................

 

[Gmoz]

I appreciate the post but that is exactly what I was trying to get around. I did not really want 31 on click procedures.

Frank