Cross application

[Paradigm]

Is there a way that I can set a value in a combo box in an openform from a
different access application. I have a number of completely seperate
applications and it would be very useful to be able to set a value in one of
them from a selection made in another.
Alec

 

[Guest]

Alec:

You'd have to create a public function in a standard module in the target
application to update the combo box, then create a reference to the target
application in the current application (Tools|References on the VBA menu
bar). The function would then be exposed in the current application and the
value to which you wish to set the combo box could be passed into it as its
argument.

Ken Sheridan
Stafford, England