I have a parent report with 4 child

[dodgyone]

I have a parent report with 4 child reports embedded for each parent record.

Each child report displays the maximum record as necessary but there may not be a suitable record and so it will be displayed as a blank.

The parent report looks at each child report to see whether the check box is ticked or not and a label is displayd depending upon this result. I've started the If statement but I get errors whenever I get to a blank child report. How can I code to tell the program to ignore and carry on if the child report is blank?

Cheers....

 

[JoeMiller]

Check the result of your iif statement for an error and respond to it by using the IsError function:

=IIf(IsError(MyIIfStatement)=True,"Error Returned",MyIIfStatement)

Replace MyIIfStatement with the IIf statement you've got that works when the Child report exists.

HTH Joe Miller
joe.miller@flotech.net

 

[dodgyone]

Sorry.... not too sure where to place the code etc.

I am using the on_format event to check these child reports... is that correct?

Thanks....

 

[JoeMiller]

In the control source of your text box. Joe Miller
joe.miller@flotech.net