Access Module:
Access Form
After MyForm has opened, string dd is nothing (in either Form_Load or Activate)
However in Excel, the only differences being
In the Userform_Activate routine the string dd is present.
Stepping through the code in Access shows the Let Property is called, but the value is lost after the Form opens.
Most likely the Access behaviour is correct, but is there any way for it to have the same result as Excel?
Thanks.
Code:
Sub zz()
Form_frmExtSingles.Tester = "1234"
DoCmd.OpenForm "MyForm", acFormDS
End Sub
Code:
Option Compare Database
Option Explicit
Public dd As String
Private Sub Form_Activate()
MsgBox dd & vbCrLf & "Activate"
End Sub
Private Sub Form_Load()
MsgBox dd & vbCrLf & "Form Load"
End Sub
Public Property Let Tester(x As String)
dd = x
MsgBox "I am setting property with " & dd
End Property
However in Excel, the only differences being
Code:
Sub zz()
MyForm.Tester = "1234"
MyForm.Show
End Sub
Stepping through the code in Access shows the Let Property is called, but the value is lost after the Form opens.
Most likely the Access behaviour is correct, but is there any way for it to have the same result as Excel?
Thanks.