#Error displays when no records

[jamlaw]

Im using Access 2007 and I have a on my switchboard a total for any bookings outstanding usuing a subform and the count funtion.

It all works fine except when there are no records then its just returns #Error

Is there a way to stop this? I've tried is null and nz function but no joy.

Thanks

 

[spikepl]

IsError combined with IIF

 

[jamlaw]

thank you, it worked!!!