I have a test program where the 1st form is "pass1"
as shown below:
Option Compare Database
Public num1 As Integer
Private Sub Command0_Click()
On Error GoTo Err_Command0_Click
num1 = 11
Dim stDocName As String
Dim stLinkCriteria As String
stDocName = "pass2"
DoCmd.OpenForm...
I have an access (2003 sp3)program
I declare public myfield as string
I can put a value in it and us it on different forms.
works great.
I send it to another user (access 2007 and access 2002)
and the same program will not allow me to put a value
in it so it is not available to other forms...
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.