Question about passing form control value to report (1 Viewer)

ridders said:

Save the value using a variable (or a tempvar if you use them)
Reference the variable in the report

Click to expand...

dkmoreland said:

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

Code:Copy to clipboard

=[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.

Click to expand...

1268 said:

SQL make table. I am not sure if the variable riders discuss will persist. Never tried.

Sent from my SM-G950U using Tapatalk

Click to expand...

dkmoreland said:

Why use make table? I don't really need to save this value past the point of generating the report.

Click to expand...

ridders said:

Repeatedly making tables will bloat your database and is totally unnecessary for this purpose

There are at least 3 ways of transferring the value from form to report
The attached example database demonstrates each of these

For simplicity I've used a public or global variable sngValue.
I could have used a tempvar but I tend not to do so

1. Get the value of sngValue in the Report load event
2. Add the value as a field in the report record source
3. Set the value using OpenArgs

In each case, the form is closed before the report loads
All work equally well - choose whichever you prefer

HTH

Click to expand...