dkmoreland
Registered User.
- Local time
- Yesterday, 21:54
- Joined
- Dec 6, 2017
- Messages
- 129
To run this report I have, a form will open on which the user will select a start date and an end date, then enter a number that will be used in a calculation on the report. The control is unbound and the value is not stored in any table - it is used for calculation only and is determined by the user.
I know that I can use this as the control's data source
However, this only works as long as the form is open. How can I pass this to the report if the form is closed? I don't want to leave it open on the screen. I don't think a Where statement will work since there is no table or query behind this control.
Suggestions, please?
Thanks in advance.
I know that I can use this as the control's data source
Code:
=[Forms]![Select KPI Date Range]![TxtNumKPINCR]
However, this only works as long as the form is open. How can I pass this to the report if the form is closed? I don't want to leave it open on the screen. I don't think a Where statement will work since there is no table or query behind this control.
Suggestions, please?
Thanks in advance.