Menu item firing 3 times

[fiep]

Hi,

I have created a custom menu button to print reports on a form. If I click the (custom) menu item the function connected to the button is executed 3 times (and the report is printed 3 times).
Of course it only has to run once. Am I doing something wrong of is it not possible to use custom menu item (with text buttons?).

I call the function using the "On action" option with:
=<functionname>

Thanks.

 

[perrymans]

Post the code for the function.

Also, perhaps "On Action" considers muberous actions such as:

Got Focus
On Click
Lost Focus

Maybe this is the source of the three? Don't know for sure, just a thought.

Sean.

 

[TheAceMan1]

How are ya fiep . . .

Your obviously calling the function correctly so the function is the culprit!

Post the full function . . .

See Ya! . . . . . .

 

[fiep]

The function only contains this:

debug.print "function called"

When I click the menu I have three lines in the debug window. What could be wrong with the function
Furthermore the only action I can think of that can be used with a menu is te onclick. But there is no choice in when te function is called so I would not know what could go wrong there.

Thanks