Is there a way to reference another forms variables without making them global variables?
so say if I am in frmEX2 I can call intIDNUM that exists in frmEX1
Is this possible?
Thanks.
Kib
you cannot get a variable used inside a forms VBA code because it's Subs are Private.
like so
Private Sub Combo1_BeforeUpdate(Cancel As Integer)
End Sub
but if you create a new Procedure in a form it is Public Public Sub Test1()
End Sub
So either move the function to a Module which is public and call it from anywhere.
Or yes as you stated make it Global.
that's what Global is there for don't worry about using it. DougP, MCP
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.