I am looking for simple way to activate OnEntryEvent code in commandbutton without clicking the button. ThrowFocus () would not work. RunEntryOnEvent( ) run amok without RemoveRunEntryOnEvent ( ) and has to establish conditional, so it does go on repeating. This worked but it is a bit more complicated. FormRunProgram( ), does it work on the same form? I am sure there must be a simpler way. I believe I had accomplished this in a lot simpler way before but cannot seem to recollect it. Please help.

Write a subroutine in the global code area. Call it from the button's on entry event and from any other bit of code you wish.

Bharat_Naik wrote on Mar 16^th, 2008 at 3:26am:


Advisable? Yes, certainly. The division of code into subroutines and functions is almost always a good idea. If it is lengthy, look for the points that mark the beginning and ending of new functionality, and make multiple functions and subroutines, maybe even multiple levels of functions and subroutines, and tie them together through invocation. The ideal being to create generic functions that can be used and reused.

If you have many variables that are declared outside of the scope of any one function or subroutine, it is likely that these should be redeclared and placed inside the new subroutines and functions as local variable. Use the parameters and return values of the functions instead to pass information from one subroutine to another. Try to avoid globals, whether static or otherwise.