[AccessD] Report #Error

I tried the suggestion below and it worked perfectly........

Thanks Jim & Michael for your responses -

Martin

----- Original Message -----
From: "Michael Welsh" <mike at welshfam.org>
To: "'Access Developers discussion and problem solving'"
<accessd at databaseadvisors.com>
Sent: Wednesday, June 09, 2004 6:58 AM
Subject: RE: [AccessD] Report #Error


> Martin
> I have always use
> IIF(IsError([YourSubformReference],0,[YourSubformReference])
> Using the IsError function to trap for the error, and the Immediate If to
> display the Zero.
>
> Mike
>
> -----Original Message-----
> From: accessd-bounces at databaseadvisors.com
> [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Martin Caro
> Sent: Tuesday, June 08, 2004 6:55 AM
> To: Access Developers discussion and problem solving
> Subject: [AccessD] Report #Error
>
> I'm building a report and have a text box that references a box within a
sub
> report. It works fine except when the sub report returns no data so I get
> #Error in the first box. I have tried to capture this event in the No_Data
> and on_error events of the main and sub reports but no luck.
>
> Any ideas where to capture this event so I can seed the referencing box
with
> zero.
>
> Martin
>
>
> --
> _______________________________________________
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
>
> --
> _______________________________________________
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
>