G
Gary Schuldt
I want to set a global variable equal to a value in a single-column unbound
combobox.
Here's the code I have:
OnExit from combo, I call this macro, which contains the single statement:
SetValue [Modules]![Module1]![pubstrCurrentGarden].[Value] = [combo]
I have the statement
Public pubstrCurrentGarden As String
In the General Declarations of Module1.
I have tried all sorts of syntaxes for the Item part of the SetValue action,
ranging from just pubstrCurrentGarden all the way up to what you see.
If it's even possible to set a global variable in a macro, please tell me
how!
Thanks.
Gary
combobox.
Here's the code I have:
OnExit from combo, I call this macro, which contains the single statement:
SetValue [Modules]![Module1]![pubstrCurrentGarden].[Value] = [combo]
I have the statement
Public pubstrCurrentGarden As String
In the General Declarations of Module1.
I have tried all sorts of syntaxes for the Item part of the SetValue action,
ranging from just pubstrCurrentGarden all the way up to what you see.
If it's even possible to set a global variable in a macro, please tell me
how!
Thanks.
Gary