Printing Text Box on form 2

[cbpwc01]

I have a complex form comprised of two subforms linked to queries, a data entry subform that links directly with a table, and a text box where users have to explain differences in the displayed results (the calculated allocations) and their entered allocations.

I need to be able to print this text box without printing the entire form so that we may file it with the final printed reports that are sent to compliance.

Any suggestions on how I go about doing this? My brain is exhausted, I'm by no means a programmer and I've spent the last week using SQL to set up queries and make this database functional--and I'm stuck on this printing problem.

Thanks in advance for your time and energy!

 

[FancyPrairie]

Add a text box to your report and set its control source equal to the text box on the form

control Source ... =Forms!YourForm!YourTextBox

 

[cghoga]

Create a new report

have one unbound textbox on the report

set the controlsource property of the textbox to the current value on the form

=Forms!nameofform!nameoftextboxonform.value

resize the textbox as needed

when printing the report use this code...

DoCmd.OpenReport "yourreportname", acViewNormal

to send directly to printer or

DoCmd.OpenReport "yourreportname", acViewPreview

to preview before sending to printer


hope this helps