ACC97: Function Called from Command Bar Control Executes 3 Times
Article ID: 162660
Article Last Modified on 1/19/2007
APPLIES TO
- Microsoft Access 97 Standard Edition
This article was previously published under Q162660
Advanced: Requires expert coding, interoperability, and multiuser skills.
SYMPTOMS
If you call a procedure in a form class module from the OnAction property
of a command bar control, the function runs three times.
RESOLUTION
Store the procedure in a standard module instead of in a form's class
module. When you call a procedure in a standard module in the OnAction
property of a command bar control, the procedure runs only once.
STATUS
Microsoft has confirmed this to be a problem in Microsoft Access 97.
REFERENCES
For more information about running a Visual Basic function from a button on
a custom toolbar, search the Help Index for "toolbar buttons, adding to
toolbars," or ask the Microsoft Access 97 Office Assistant.
Additional query words: menu command bar tool class
Keywords: kbbug kbusage KB162660