Placing Text from a form on a report

[tbonehwd]

I have a form that users enter criteria to pull data from our SQL server and get an Access report with the results. I would like to add a field to the form that would allow them to describe what they ran and then place that descriptive text on the report in the header so when they print it they know what it is. Has anyone done somthing like this if so could you give me an idea?

Thanks,

TBonehwd

 

[floydpepper]

I ran into the same challenge a few months back. Here's what worked for me:

For each criteria, place unbound text boxes in the report header. Set the Control Source for each text box to the appropriate crieria (e.g. = Forms![Criteria Form]![Criteria Text Box name]). This data will appear on the report.

If you want a single line of descriptive data, just add the extra unbound field to your criteria form and follow the steps listed above.

As long as your criteria form Modal property is set to "Yes", then this should work.

I hope this helps.

FloydPepper

 

[tbonehwd]

Thank you that worked perfect