I set up a report that is opened from a form that has Unbound check boxes. The checks are used in my code to hide or show the relative controls on the report.
Also I coded the Detail section "On Format" event to calculate the spacing for when a Control is not selected to be shown... essentially I do all the math to alter the size and position of the controls that will be shown ( it is a group of 4).
The problem is I have to keep the form Open in order to have it print, I want it to be a popup and then close as report opens.... I can do it, but when I actually want to print I get an error rendering the report.
Should I have a variable or function separate from each to hold the values? Can I force the form to close after the report opens, via a Report event?
**Note I am formatting in the Page Header and Detail sections
this is an example I use in the code to pass the variable, I tried placing it in the report Open event and putting the variable declaration at the top ( below Option explicit), but no luck.
Just need a nudge ( or kick if you preferr in the right direction.
Also I coded the Detail section "On Format" event to calculate the spacing for when a Control is not selected to be shown... essentially I do all the math to alter the size and position of the controls that will be shown ( it is a group of 4).
The problem is I have to keep the form Open in order to have it print, I want it to be a popup and then close as report opens.... I can do it, but when I actually want to print I get an error rendering the report.
Should I have a variable or function separate from each to hold the values? Can I force the form to close after the report opens, via a Report event?
**Note I am formatting in the Page Header and Detail sections
this is an example I use in the code to pass the variable, I tried placing it in the report Open event and putting the variable declaration at the top ( below Option explicit), but no luck.
Code:
Frm_std20 = Forms!frmPrintMenu.chk20std
Just need a nudge ( or kick if you preferr in the right direction.
Last edited: