Hi,
I have a form in which it gathers looks up info on many tables and makes some calculations sort of a quotation. I will like to print the information I submit in the form but what I don't like is to print all color and images and text boxes. I will like to print a report type paper with all the information that I submit on the form, all with just on click on the form.

I am not sure if this is the best way, or if it will even work, but what about if you were to create a report, and in the fields put something like...

=Form_frmMyFormName.txtFieldName

then on the button click, do a

DoCmd.OpenReport "rptMyReportName"

Hope that helps

Mike

Other solutions, could be building the report using VBA (Fun for a total geek like me) or load a table with the data, and opening a form bound to that table.

Mike
EchoVue.com

ok

the button in the form is doing exactly what i want

but the txt fields in the form are printing #Name?

thanks