Adding Notes to report

[Digsys]

Can someone please advise me as to how to add notes onto a report before I print it. I would like to have a pop-up form into which the user would enter a line or 2 of text and when the pop-up form closes, have the entered text print out on the report . The report is based on a query.
Thanks

 

[LonnieJohnson]

1. Create a new form with a text box and a command button.
2. Add a new unbound field to your report.
3. Now in the On Click event that once opened your report, change the code to open your new form.
4. When the form is opened, have your users to type the information you want into this text box.
5. In the On Click event of the command button. Open your report.
6. In the report's On Open event put code that will set your new Unbound text box on the report equal to the text box on the new form and close the form.

Just a rough draft. I'm sure there may be other ways to do it. This is my way at first glance. prodevmg@yahoo.com
ProDev, MS Access Applications B-)

http://www.galaxymall.com/software/PRODEV

May God bless you in the year 2002.

 

[backer]

Report Design View/ Add a text Box - in the control source enter [whatever instruction you want to give data entry person]. Note the brackets - this will cause a propmt for data entry when you first open the report.

 

[Digsys]

Thanks Lonnie and Backer. Both solutions work, but I have gone for Lonnie's as it gives me more flexibility. Thanks again