how to call sub richaluft[ at ]cs.com 12/6/2008 12:46:39 AM Hope someone can remind me how to do the following. From an after_update event of a control on a form, I'd like to call the 'on current' sub of the same form. richard

RE: how to call sub Daniel Pineault 12/6/2008 1:17:02 AM Firstly, you must change the sub you wish to call (Me.Form_Current) from Private to Public. Then in the sub from which you wish to make the call from enter Me.Form_Current -- Hope this helps, Daniel Pineault http://www.cardaconsultants.com/ For Access Tips and Examples: http://www.devhut.net Please rate this post using the vote buttons if it was helpful. "richaluft[ at ]cs.com" wrote: [Quoted Text] > Hope someone can remind me how to do the following. > From an after_update event of a control on a form, I'd like to call > the 'on current' sub of the same form. > richard >

RE: how to call sub Bob Quintal <rquintal[ at ]sPAmpatico.ca> 12/7/2008 2:52:27 AM =?Utf-8?B?RGFuaWVsIFBpbmVhdWx0?= <DanielPineault[ at ]discussions.microsoft.com> wrote in news:148E2DB0-3FDB-4FFA-9BA0-C8537D022E48[ at ]microsoft.com: [Quoted Text] > Firstly, you must change the sub you wish to call > (Me.Form_Current) from Private to Public. Then in the sub from > which you wish to make the call from enter > > Me.Form_Current No need to make a procedure public if it's called from within the same module. It is required when calling from one module to another -- Bob Quintal PA is y I've altered my email address. ** Posted from http://www.teranews.com **