How do you add expressions to a reports header? My report is called "Commercial Application Register". It is a report for the previous months applications. I would like it to say "Commercial Application Register For Month Of (Previous month/year).
How do you add expressions to a reports header? My report is called "Commercial Application Register". It is a report for the previous months applications. I would like it to say "Commercial Application Register For Month Of (Previous month/year).
Use a textbox instead of label.
Set ControlSource to:
="Commercial Application Register for Month Of " & [month/year]
Trick is passing the month/year to the expression. Is this a value that is included in the RecordSource of the report? Other techniques are:
1. reference to controls on form where user has entered the month and year criteria
2. use OpenArgs argument of DoCmd.OpenReport to pass the string to report and then reference the OpenArgs to grab the value
="Commercial Application Register for Month Of " & [OpenArgs]
How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.