Eventprocedure to work with switchboard

[Tari]

Hi,



I have a button on one of my forms that runs the following event procedure:

Private Sub cmdAltOrder_Click()
Dim altorder As String
Dim numaltorder As Long
altorder = InputBox("Enter the order number for which you want a summary", "Enter Order Number")
If IsNumeric(altorder) Then
numaltorder = CLng(altorder)
If DCount("*", "[order details]", "[RTP number]=" & numaltorder) > 0 Then
DoCmd.OpenReport "Orders Summary", acViewPreview, , "[OrderID]=" & numaltorder
Else
MsgBox "No summary is available for the order number you entered"
End If
Else
MsgBox "Value entered is not a number"
End If
End Sub

I would like to make that work from the switchboard. I have to create a macro to do the event procedure above, but unfortunately I don't know macros -.-

Would somebody give me a hand?

Thanks!

[Robeen]

Why do you 'have to' create a Macro for this?

[Tari]

Why do you 'have to' create a Macro for this?

I don't have to have to.. if you can show me another way to do it, happy to learn

[Robeen]

You said:

I have to create a macro to do the event procedure above

. . . that's why I asked why you had to.

Can you not add a button to your switchboard and then put the code into that button?

[Tari]

You said:
Can you not add a button to your switchboard and then put the code into that button?

*sigh* of course..

I used the switch board manager to create the switchboard and it only gave you a few limited options and what the switchboard item can do. I created a button with the wizard and came to the same limitations.

I was not thinking that I could create an entry with the switchboard manager and then go into design view and put my code behind it -.-

Maybe I should go have some more coffee..

thanks for the nudge Robeen