Invoking function on form with Toolbar button

[KeithWilliams]

Hi,

I have a window with a command button that calls a function on the window. That works great, but I want to replace the command button with a toolbar button on a custom toolbar.

I don't understand in general how to achieve this. Here's what I have so far:

1. A window named Performance, with VB function DistributeValue()

2. A custom toolbar named ToolbarPerformance, with a single button, with its OnAction set to MacroSwitchboard.DistributeYearToMonths

3. A macro with macro name DistributeYearToMonths, comprising a RunCode action with Function Name = DistributeValue ( )

4. I've assigned "ToolBarPerformance" to the Toolbar property of the form Performance.

When I run and click the toolbar button, I get the error:
"The expression you entered contains invalid syntax. You may have entered a comma without a preceding value or identifier."

I've varied the syntax of the macro's function call, without success.

I'd love to do without macros altogether, but the OnAction field in the toolbar button's properties only offers my existing macro names as choices for the action to perform. I tried just typing Performance.DistributeValue () to reference the VB code directly, but this caused MSAccess.exe to crash.

Please help with this, as the rest of my application is working so sweetly!

Many thanks,
Keith.

 

[doran_doran]

I think you can achieve this through Macro

I am not sure but I think you can achieve this through Macro. I have never tried it myself.

Good Luck
Dianna Goldsberg

 

[Rich]

In the OnAction = FunctionName()

 

[KeithWilliams]

Hi Rich,

That worked great! In the OnAction I put:
"= DistributeValue ( )"
which references the function in the active form when the toolbar is visible. I had tried before but didn't think to put the =, which produced a weird message about the macro or "callback function" not being found (something to do with OLE?)

Thanks so much,
Keith.