Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Parameters Won't Print In Report

Status
Not open for further replies.

crisis2007

Technical User
Apr 2, 2007
114
US
I created a criteria form that calls for 2 different parameters. I placed a command button on the criteria form that calls a report from the query that relies on the parameters. The report pops up in preview with the parameters correctly visible in text boxes that I use to show the parameters used for the report. (The report pops up behind the criteria form). I have a command button that closes the criteria form. Everything looks just as I want it with all the correct details in the preview. However, when I go to File>Print, the report prints out with all the correct information, however the text boxes for the parameters each show #Name? I am still somewhat of a beginner, using MS Access 97. I am also very new to code and usually learn the hard way on everything. I have searched but can not find how to correct this.
 
Don't close the form if you need values from it in the report. Just set its visible property to false.

Duane MS Access MVP
[green]Ask a great question, get a great answer.[/green] [red]Ask a vague question, get a vague answer.[/red]
[green]Find out how to get great answers faq219-2884.[/green]
 
Thank You! That did the trick. I truly appreciate the help!
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top