Fordraiders
asked on
how to get value from an object on another access form for global variable
I have a main form that when open, i'm wanting to set a global variable
LABEL_CURRENT_REVIEW_DATE is a label on "RUN_BUILD_FORM"
In a module:
Global CSP_REVIEWDATE_CRITERIA As String
On my main form load event
Private Sub Form_Load()
' this is the main form loading at startup
CSP_REVIEWDATE_CRITERIA = Forms!RUN_BUILD_FORM!LABEL _CURRENT_R EVIEW_DATE
End Sub
I cant seem to get the code correct to grab the current value on the form. "RUN_BUILD_FORM"
Thanks
fordraiders
LABEL_CURRENT_REVIEW_DATE is a label on "RUN_BUILD_FORM"
In a module:
Global CSP_REVIEWDATE_CRITERIA As String
On my main form load event
Private Sub Form_Load()
' this is the main form loading at startup
CSP_REVIEWDATE_CRITERIA = Forms!RUN_BUILD_FORM!LABEL
End Sub
I cant seem to get the code correct to grab the current value on the form. "RUN_BUILD_FORM"
Thanks
fordraiders
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER