Hi,
I was wondering if anyone knows a way in which to display a parameter on a report's header, when the report contains no data (that is, when the query on which the report is based on, does not find any records with the manually entered parameter).
I've added a text box with its control source as the parameter, and it does show up on the report when the query does get hits. I'd like it to show up on the report as well when the query does not find any records.
Any help would be greatly appreciated.
I was wondering if anyone knows a way in which to display a parameter on a report's header, when the report contains no data (that is, when the query on which the report is based on, does not find any records with the manually entered parameter).
I've added a text box with its control source as the parameter, and it does show up on the report when the query does get hits. I'd like it to show up on the report as well when the query does not find any records.
Any help would be greatly appreciated.