Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations TouchToneTommy on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
'Public' variables on Reports? 1
- Thread starter solo7
- Start date
-
1
- #2
Hi!
Declare a function in one of your modules to fetch the variable, and then plase the function name as controlsource for the control in your report.
Function GetVariable() as "DataType"
GetVariable=YourPublicVariable
End Function
In your report controls controlsource, place;
=GetVariable()
Roy-Vidar
Declare a function in one of your modules to fetch the variable, and then plase the function name as controlsource for the control in your report.
Function GetVariable() as "DataType"
GetVariable=YourPublicVariable
End Function
In your report controls controlsource, place;
=GetVariable()
Roy-Vidar
LarryDeLaruelle
Technical User
Solo7:
If you just want to display the values in the report you can use:
Forms!frmFormName.txtFieldName
Larry De Laruelle
larry1de@yahoo.com
If you just want to display the values in the report you can use:
Forms!frmFormName.txtFieldName
Larry De Laruelle
larry1de@yahoo.com
- Status
Similar threads
- Locked
- Question
- Locked
- Question