Hi, everyone.
I have a problem in my report printing. I use a control form to extract monthly report. In my query I set a field with critria [forms]![controlform]![textbox]. I set an unbound text box in control form to enter value of the criteria such as 1-12 as month. After enter value in text box, the user run command button to run query and get the report. The header in the report also use [forms]![controlform]![textbox] to control to show it is which month's report.
I use macro to control command button to run query and to open report. Under the action of Open report, I set view as Print Preview. It works fine. But after user preview report and want to print it. The header in the printout shows "#Name", it seems it does not get the value of the criteria as in Print Preview Status.
Could anybody help me out? Many thanks.
I have a problem in my report printing. I use a control form to extract monthly report. In my query I set a field with critria [forms]![controlform]![textbox]. I set an unbound text box in control form to enter value of the criteria such as 1-12 as month. After enter value in text box, the user run command button to run query and get the report. The header in the report also use [forms]![controlform]![textbox] to control to show it is which month's report.
I use macro to control command button to run query and to open report. Under the action of Open report, I set view as Print Preview. It works fine. But after user preview report and want to print it. The header in the printout shows "#Name", it seems it does not get the value of the criteria as in Print Preview Status.
Could anybody help me out? Many thanks.