Microsoft Access
--
Questions
--
Followers
Top Experts
AccessReports: Display Subreport even if its record source has no records
I have a subreport on a report.
The report header and report footer in the subreport have labels and textboxes that I want to always show on the main report.
My Problem: If the query in the recordsource of the subreport has no records, the subreport will not show on the main report. Does anyone know how to make my subreport always show, even if the query in its recordsource has no records?
The report header and report footer in the subreport have labels and textboxes that I want to always show on the main report.
My Problem: If the query in the recordsource of the subreport has no records, the subreport will not show on the main report. Does anyone know how to make my subreport always show, even if the query in its recordsource has no records?
Zero AI Policy
We believe in human intelligence. Our moderation policy strictly prohibits the use of LLM content in our Q&A threads.
ASKER CERTIFIED SOLUTION
membership
Log in or create a free account to see answer.
Signing up is free and takes 30 seconds. No credit card required.
Awesome!! Genius!! Thanks!!!
EARN REWARDS FOR ASKING, ANSWERING, AND MORE.
Earn free swag for participating on the platform.
Microsoft Access
--
Questions
--
Followers
Top Experts
Microsoft Access is a rapid application development (RAD) relational database tool. Access can be used for both desktop and web-based applications, and uses VBA (Visual Basic for Applications) as its coding language.