[AccessD] Expense subreport

Jim Lawrence accessd at shaw.ca
Tue Feb 14 23:01:53 CST 2012


Hi John:

Not sure whether it will work in this case but to counteracts nulls I have
found, in some cases, adding a zero (+0) solves it. The other way would be
through code like: on error; hide subform.

Jim 

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of jwcolby
Sent: Tuesday, February 14, 2012 8:24 PM
To: Access Developers discussion and problem solving
Subject: [AccessD] Expense subreport

I am adding an expense subreport to my invoice.  When there is data (one or
more records) in the 
subreport all is copacetic, however when there is no data, the subreport
disappears entirely and the 
controls up on the main report which reference the controls in the subreport
display #Error.

Any suggestions as to how to handle this?  Do I have to "fake" data for this
case?

-- 
John W. Colby
Colby Consulting

Reality is what refuses to go away
when you do not believe in it

-- 
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com



More information about the AccessD mailing list