Hi!
I'm trying to create by-pass of OpenArgs for my form as I want to use form instances and OpenArgs is read-only + new instances cannot be created using DoCmd.OpenForm.
I have read through various forums how to pass this alternative OpenArgs to new form instance so I created in Form's module (that form I want to create various instances of...):
I'm successful with passing my OpenArgsAlt from another form (Debug.print in LET property sucessfuly prints value I passed), however when I want to use Property in form's Form_Open event, both OpenArgsAlt Property but also strOpenArgsAlt variable appears empty.
Do you have any idea what I'm doing wrong?
Many thanks guys!
I'm trying to create by-pass of OpenArgs for my form as I want to use form instances and OpenArgs is read-only + new instances cannot be created using DoCmd.OpenForm.
I have read through various forums how to pass this alternative OpenArgs to new form instance so I created in Form's module (that form I want to create various instances of...):
Code:
Option Compare Database
Option Explicit
Dim strOpenArgsAlt As String
Public Property Let OpenArgsAlt(InputArgs As String)
strOpenArgsAlt = InputArgs
End Property
Public Property Get OpenArgsAlt() As String
OpenArgsAlt = strOpenArgsAlt
End Property
I'm successful with passing my OpenArgsAlt from another form (Debug.print in LET property sucessfuly prints value I passed), however when I want to use Property in form's Form_Open event, both OpenArgsAlt Property but also strOpenArgsAlt variable appears empty.
Do you have any idea what I'm doing wrong?
Many thanks guys!