<div>
Technically they don't have a return value. They have a Cancel Parameter which is passed ByRef (default).<br>For cancelling the event, you could try something like this:<br><pre><code class="code-1 nolinks" id="code-20-43088062-1"><span>Public Function GlobalBeforeUpdate()</span>
<span>&nbsp; &nbsp; Screen.ActiveControl.Undo</span>
<span>&nbsp; &nbsp; DoCmd.CancelEvent</span>
<span>End Function</span>
</code></pre>The alternative, could be that you use a class module, and use WithEvents to listen for the event(s) instead.<br><br>You can see some examples here:<br>​<a href="https://accessexperts.com/blog/2012/10/22/maximizing-code-reuse-multiple-event-handlers/" rel="ugc">Event Handlers</a>​​​
</div>


Richard Badenhop

<div>
I will try the class first. Nice. Allthough I recall Access not being user-event friendly.
</div>


<div>
and note that you can pass values in. Ie.:<br><br>=StdFormCT([Form],"OnOpenForm","")<br><br>Jim.
</div>


<div>
The only way for an event handler to return a value (as with any procedure) is to use a parameter given by reference.<br><br>But, keep in mind that event handler have a precise signature, wich cannot be changed at will, thus the targeted event handler must accept parameters in the first place.
</div>


<div>
<div class="content wysiwyg-content">
Normally if I want to do something with an event in a control on a form I use &quot;[Event procedure]&quot; and handle it in VBA. So somthing like Private Sub SomeControl_BeforeUpdate(C<wbr />ancel As Integer) is handled in VBA and the Cancel variable is set there. The control then reacts to the new value of the cancel-variable. Works great.<br />
<br />
Now I have a situation where a control is added dynamically on a form. I don't create any VBA but I do set (in design): SomeControl.OnBeforeUpdate<wbr /> = '=GeneralHandler()'<br />
<br />
In that public call I then use screen.activecontrol to act on it.<br />
<br />
But is it possible to give return values back? So if GeneralHandler() decides that the beforeUpdate should be cancelled, how do I &nbsp;return this variable so that the controls acts in a normal behaviour.<br />
<br />
It is not only an issue with BeforeUpdate. Even more with NotInList and all other events with return variables.<br />
<br />
Suggestions how to do that?
</div>
</div>


Normally if I want to do something with an event in a control on a form I use "[Event procedure]" and handle it in VBA. So somthing like Private Sub SomeControl_BeforeUpdate(Cancel As Integer) is handled in VBA and the Cancel variable is set there. The control then reacts to the new value of the cancel-variable. Works great.

Now I have a situation where a control is added dynamically on a form. I don't create any VBA but I do set (in design): SomeControl.OnBeforeUpdate = '=GeneralHandler()'

In that public call I then use screen.activecontrol to act on it.

But is it possible to give return values back? So if GeneralHandler() decides that the beforeUpdate should be cancelled, how do I  return this variable so that the controls acts in a normal behaviour.

It is not only an issue with BeforeUpdate. Even more with NotInList and all other events with return variables.

Suggestions how to do that?

Return variables using procedure/function in events in MS-Access

Microsoft Access is a rapid application development (RAD) relational database tool. Access can be used for both desktop and web-based applications, and uses VBA (Visual Basic for Applications) as its coding language.

Microsoft Access

Visual Basic for Applications (VBA) enables building user-defined functions (UDFs), automating processes and accessing Windows API and other low-level functionality through dynamic-link libraries (DLLs). VBA is closely related to Visual Basic and uses the Visual Basic Runtime Library, but it can normally only run code within a host application rather than as a standalone program. It can, however, be used to control one application from another via OLE Automation. VBA is built into most Microsoft Office applications.