how do i get form variables on report without openargs

[petebob796]

My situation is a form is opened where a user enters query constraints. Then they press go, this runs a bit of vba code which opens a report (the report is linked to a query which references the form object and seems to work).

The report shows at the top the query constraints referenced directly from the form objects again.

However the form then closes itself in the vba code. So if I were to print these wouldn't display properly. Is there a way to pass these arguments on the form open before the form closes and store them without using the openargs as there are a fair few arguments which I don't want to have to parse.

 

[neileg]

Not sure what the issue is. If you have opened the report in preview and it has the parameters embedded in the report, then when you print the report from the preview, it doesn't re-run the report, it just prints from the report image in memory.

Or rewrite the code so that the form doesn't close (perhaps just minimise it) until after you've promted the user to print.