Adding Info to a Report

[Guest]

I have a form which is used to input monthly crime statistic information.
I've added some code to the Print Report command button which will prompt the
user with an input box to enter the month that the report will cover. I would
like to be able to take that information (the name of the month that the user
entered) and have it appear in the Title section of the report header. I've
been trying to figure this out for several days. Any ideas would be greatly
appreciated. I am new and just starting to learn VBA for Access. Thank You

 

[Douglas J. Steele]

Presumably you've done something like put a criteria along the lines of
[Enter Month] under a field in the query that makes up the RecordSource for
the report. Add a text box to your report, and set its ControlSource to
something like = "Report for details in " & [Enter Month] (including the
equal sign). Make sure the reference to the criteria is typed identically in
the control source, or you'll end up getting prompted again.