subform checker

[kingsgambit]

On my main form I have two subforms, one for parts and one for labour. When I select what parts the customers wants and what type of labour they require and how many hours. I can click produce invoice report and that works fine.
But if I don't select either parts or labour the report shows errors because it can't calculate the price and labour. How can I get it to check if each subform has a item in it, and if no item has been select give the record a zero value

 

[KingKong]

kingsgambit,

check this thread:

http://www.access-programmers.co.uk/forums/showthread.php?s=&threadid=50626

and then this one:

http://www.access-programmers.co.uk/forums/showthread.php?s=&threadid=44668


Grtz,

Peter.

 

[Rich]

You have to use the HasData method, search the reports section for examples