CommandBar function call w/o parens runs function 2-3 times

M

Mark Hammer

Anybody seen this one? In Access 2002.

A command bar function call with no parentheses runs a public function
behind a form two or three times, for no reason that I can see.

So, when the command bar properties include

On Action: "=TestCmdBarFunction"

and the function is in a form's code, the function runs twice or three
times.

Add parens and the function only runs once; so,

On Action: "=TestCmdBarFunction()"

runs the function just once.

Had me stumped for awhile. Someone out there got an explanation for this
behavior?

--Mark Hammer
Lake Oswego, Oregon, U.S.
 
Top