Subreport problem when no record exists

  • Thread starter Thread starter AkAlan via AccessMonster.com
  • Start date Start date
A

AkAlan via AccessMonster.com

I have a text box that calculates data from other text boxes, one of which is
from a subreport. When there are no records for the subreport the calculated
text box gives me a #ERROR. I have tried the nz function but still get the
error. I would like to trap for no records in the subreport so I can run some
code but can't figure out how to do that. Thanks for any help.
 
You should provide the control source of the text box. However, generically,
you can use:
=IIf(sbrptControl.Report.HasData, sbrptControl.Report!txtName, 0)
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

No Record in Subreport 1
Subreports 1
Which subreport Event to use 5
Access How to prevent subReport from breaking across pages? 1
Subreport with no records 8
# Error when no data 4
SynNeed to account for null values in subreports 2
Return Totals for multiple categories from a subreport 4

Back
Top