Access Popup Parameter 1

[WordTechinc]

I have a Access report which is created with recordsoure of parameter query. I want to print this report from FORM and pass paremeter from FORM text box value. How can I print report without POPUP parameter from the FORM. I have to keep parameter query recordsorce on the report. I also try not to create duplicate the report with different recordsource. Help me!!!

 

[dhookom]

The form should be open prior to running the report. Why do you "have to keep parameter query"? IMO, parameter queries have no place in any software.

I typically use the WHERE CONDITION of DoCmd.OpenReport to apply report filtering.

Duane
Hook'D on Access
MS Access MVP