how to get value from an object on another access form for global variable
Posted on 2016-11-09
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_REVIEW_DATE
I cant seem to get the code correct to grab the current value on the form. "RUN_BUILD_FORM"