Text Box on report, needs to show value on subreport, even if subreport not there !

[Davepacey]

Hi Folks, hope someone can help me on this one.
I have a report that contains several subreports, each subreport has several fields that are totalled in a text box. I need to have a textbox on my report that shows the value from this textbox on the subreport....easy enough to do that. My problem arises when the subreport is not there because the underlying query returns no records. In this case, I need the textbox on my report to show the value 0 (zero).

please help !

TIA. Dave

 

[Rich]

=IIf([SubRptName].[Report].[HasData],[SubRptName].[Report]![TextBox],0)

 

[Davepacey]

Hi,
Thanks for your help, where would I put this ? I have tried allways with it. maybe I am just a bit thick

 

[Rich]

Add the syntax as the control source for an unbound textbox on your main report.

 

[Davepacey]

Thanks Rich, I had got it sussed shortly after posting. Thanks.
Don't suppose you could help with this one.
I have a form that has a subform used for data entry, is there anyway that I can make a field on the subform default to the value of the same field in the previous record on the same subform? I know I can fill the field using a link between the subform and master and link fields on the master, but this will not work for me, (I have some fields that are linked and this works) but I need to be able to change the data.

Regards,

Dave