Set control AfterUpdate event to procedure in another module

  • Thread starter Thread starter morleyc
  • Start date Start date
M

morleyc

Hi, i know i can set a controls AfterUpdate event to a user defined
procedure if it is in the same module as the code, however is it
possible to set it to a procedure in a different module? i.e. By
setting in the OnFormLoad() event:

cbo.AfterUpdate = "=Module1.Translate()"

I cant get it to work, it just says "the expression you entered has a
function name that microsoft office access cannot find". The Translate
procedure is public. Any thoughts much appreciated.

Thanks in advance,

Chris
 
If Module1 is a standard module (not a class module, and not the module of a
form/report), and Translate() is a public function that is uniquely named
(not a Sub, not private, not ambiguous), you can just use:

cbo.AfterUpdate = "=Translate()"
 
Hi, i know i can set a controls AfterUpdate event to a user defined
procedure if it is in the same module as the code, however is it
possible to set it to a procedure in a different module? i.e. By
setting in the OnFormLoad() event:

cbo.AfterUpdate = "=Module1.Translate()"

I cant get it to work, it just says "the expression you entered has a
function name that microsoft office access cannot find". The Translate
procedure is public. Any thoughts much appreciated.

Thanks in advance,

Chris
Click to expand...

Why not just call the function from the AfterUpdate event itself? Instead of
using it as the expression you are, use the event proceedure...

Private Sub cbo_AfterUpdate()
Call Translate
End Sub
 
If Module1 is a standard module (not a class module, and not the module of a
form/report), and Translate() is a public function that is uniquely named
(not a Sub, not private, not ambiguous), you can just use:

cbo.AfterUpdate = "=Translate()"
Click to expand...
Thanks Allen,

I think i may have it as a procedure... it is in a seperate module and
it is declared public. When you mention it im sure its a sub, i'm sure
subs work when they are in the same module of the form?

Cheers,

Chris
 
Why not just call the function from the AfterUpdate event itself? Instead of
using it as the expression you are, use the event proceedure...

Private Sub cbo_AfterUpdate()
Call Translate
End Sub
Click to expand...

Its complicated for a reason! I want a modularised combo filtering
code that is generic, seems VBA is a bit limiting. Ideally i would
like to have control events call directly into member methods but it
seems this is not possible. Im therefore left with no choice but an
event registration mechanism which calls back to a single function,
from where an identifier is used to work out which object the callback
is for... if that makes sense! once i can get the callback working it
will work.
 
Note, though, that the function doesn't have to return a value, so all you
have to do is change it from Sub to Function.
 
You cannot use a Sub in an event property like that.
Functions only.
Click to expand...

After wasting an entire afternoon yesterday thank you so much, it
indeed works now. I had to do this so i can register control events to
callback into class methods which will make my form code much more
modular! Thanks again

Thanks,

Chris
 
Back
Top