Brad Marks
BradM at blackforestltd.com
Mon Dec 16 19:37:41 CST 2013
Rocky, Thanks for the help. Unfortunately, I seem to be having "senior moments" and I cannot even get a small test example to work. Perhaps you could post more details. For example, I am not sure how to obtain the record count of the sub-report. Thanks, Brad -----Original Message----- From: accessd-bounces at databaseadvisors.com on behalf of Rocky Smolin Sent: Thu 12/5/2013 10:26 PM To: 'Access Developers discussion and problem solving' Subject: Re: [AccessD] Need to Suppress Main Report Line if therelatedSub-Report has no Data I would use the format event of the detail section to get the record count of the sub report and, if it's zero then Me.MoveLayout = False Me.NextRecord = True Me.PrintSection = False HTH Rocky -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Brad Marks Sent: Thursday, December 05, 2013 5:17 PM To: Access Developers discussion and problem solving Subject: [AccessD] Need to Suppress Main Report Line if the relatedSub-Report has no Data All, I have a report that has one sub-report. This sub-report is tied to a field in the detail lines of the main report. Recently, our users requested that if there is no data in the sub-report they would like to see the related line on the main report suppressed. I have never tried to do this before. I have set up a little test Access application and tried a few ideas, but have not found a good solution. Is there a way to accomplish this with Access 2007? Thanks, Brad -- AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com -- This message was scanned by ESVA and is believed to be clean. Click here to report this message as spam. http://h0stname/cgi-bin/learn-msg.cgi?id=6A8F528AEB.B87B1