revver
Active Member
- Joined
- Dec 20, 2007
- Messages
- 257
I thought this would be simple but ...
Background
I have a module mdlGlobal which contains
and I have frmRrelink which launches at startup and whose Open event ends with
It then loads frmMenu and closes itself. At this point, in the immediate window
. Debug.Print gstrEntityName
gives the correct reply.
Problem
frmMenu contains txtFormBanner in the form's header. I want to include the contents of gstrEntityName in the banner. I tried a ControlSource of =[gstrEntityName] & vbCrLf & "Contact Menu"
but I get #Name? error
even =[gstrEntityName] gives #Name?
What am I missing?
Background
I have a module mdlGlobal which contains
Code:
Public gstrEntityName As String 'declare global Entity variables
Public gstrEntityWWW As String
------------------------------------------------
Public Sub SetGlobals()
gstrEntityName = DLookup("EntityName", "Administration", "AdminID =1")
gstrEntityWWW = DLookup("Website", "Administration", "AdminID =1")
End Sub
Code:
SetGlobals
. Debug.Print gstrEntityName
gives the correct reply.
Problem
frmMenu contains txtFormBanner in the form's header. I want to include the contents of gstrEntityName in the banner. I tried a ControlSource of =[gstrEntityName] & vbCrLf & "Contact Menu"
but I get #Name? error
even =[gstrEntityName] gives #Name?
What am I missing?
Last edited: