Calling a macro from a menu item

[BarryG]

I have a controlbutton object attached to a menu. The OnAction property works well if I do a straight call to a Sub procedure. However, I have a different Sub procedure that takes arguments. When I try to place 'Call ' in front of the Sub name in the OnAction property, the macro is not found. Is there a way to call a procedure with arguments from a control button?

Thanks in advance,
Barry

 

[JoaoTL]

Pass the Sub to Public and their Variables

e.g.

Public Sub Whatever()

Public Var as String
Public Var2 as Byte
......
......

End Sub
Best Regards

---
JoaoTL
mail@jtl.co.pt
MS Access Site:

http://www.jtl.co.pt

The Page:

http://www.jtl.co.pt/Access

moved to

http://www.jtl.co.pt

 

[BarryG]

Thanks Joao.

The only way to accomplish this was to use the Application.Caller method to determine which menu item was being clicked. This method returns and integer that indicates the menu index.

Thanks for your suggestion.
Barry