Call combo box afterupdate event for another form? 1

[glgcag]

I am trying to refresh information on a different form from a lookup form. I need to call the "different" form's afterupdate event on a particular combo box.

How do I refer to the control on the other form and call it's afterupdate event? (I've tried setting ctl = differentform.control and then coding "Call ctl_afterupdate" but it doesn't work.)

Any help is appreciated!

GLGCAG

 

[rjoubert]

Try...

Forms!differentform.Control
Or
Forms!differentform.Controls("NameofControl")

 

[glgcag]

OK, what I'm doing is this:

dim ctl as control

set ctl = Forms!fRMProjects.Controls("cmbProject")
Call ctl_AfterUpdate

But I'm getting an error.

 

[PHV]

Modify cmbProject_AfterUpdate to be Public instead of Private and then simply call it:
Call Forms!fRMProjects.cmbProject_AfterUpdate

Note: fRMProjects should obviously be open.

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886

 

[glgcag]

When I make the AfterUpdate event public and type in:

Call Forms!fRMProjects.cmbProject_AfterUpdate

I get an error that highlights the first ! and says Compile Error: expected . or (

 

[PHV]

And this ?
Call Forms("fRMProjects").cmbProject_AfterUpdate

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886

 

[glgcag]

It worked! Thanks PHV and rjoubert for the help!