Report Header Print Error

xxlu

Registered User.
Local time
Today, 08:45
Joined
Jun 28, 2001
Messages
12
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.
 

Users who are viewing this thread

Back
Top Bottom