On Current Event

[Guest]

Hi,

Which takes precedence on a form? The VBA OnCurrent event or a macro
attached to the OnCurrent Event. Can two separate events be run in this
manner?

 

[George Nicholson]

How would you assign both?

AFAIK, the properties window only allows you to specify that one of the two
will fire when the event is triggered. I suppose you could have a macro call
the Event code or have the event code call a macro (but can't think of a
reason why you'd want to). If you went that route the "precedence" would be
entirely up to you.

HTH,

 

[Guest]

If a macro were assigned to the event, any VBA code would have to be called
from a Runcode action in the query.
If the event is VBA, you can run the macro from VBA, but what is the point
of either?
If you are trying to avoid VBA, you are limiting the capabilities of your
applications.