RUN ANOTHER ACCESS VBA CODE

S

souris

May I run App1 VBA function code from App2?
If yes, which command can make it work?

Any information is great appreciated,

Souris,
 
A

Arvin Meyer [MVP]

You set a reference to App1 in App2. If you want to run a form, you write a
public sub or function in a standard module to open it:

App1:

Public Sub OpenContractors()
DoCmd.OpenForm "frmContractors"
End Sub

App2:
Set a reference to App1 then:

Private Sub cmdOpenContractors_Click()
OpenContractors
End Sub
--
Arvin Meyer, MCP, MVP
Microsoft Access
Free Downloads
http://www.datastrat.com
http://www.mvps.org/access
 
Top