How can I pass a string value into the variable on another form.
Example Setup:
Form XYX
========
Dim strData As String
strData = 123
Forms![ZYX].strLocation = strData
Form ZYX
========
Public strLocation As String
Printable View
How can I pass a string value into the variable on another form.
Example Setup:
Form XYX
========
Dim strData As String
strData = 123
Forms![ZYX].strLocation = strData
Form ZYX
========
Public strLocation As String
declare the variable in a module as Public
Then set the variable as such
VB Code:
variable = forms![ZYX].textbox1.text