Getting an Error when there is nothing to show

[Bob]

--
The bottom of my report which is a statement shows #Error when there is no
Invoices to add up. Can I have it blank instead. this my text Box Control
Source
thanks for any Help....Bob

=Reports!rptOwnerPaymentMethod!subChildOwnerInvoiceAmount!tbAmount.Value

 

[Allen Browne]

Try:
=IIf([subChildOwnerInvoiceAmount].[HasData],
[subChildOwnerInvoiceAmount].[tbAmount])

Explanation in:
Bring the total from a subreport onto a main report
at:
http://allenbrowne.com/casu-18.html

 

[Bob]

Thanks Allen but got the #Name?......Bob

Try:
=IIf([subChildOwnerInvoiceAmount].[HasData],
[subChildOwnerInvoiceAmount].[tbAmount])

Explanation in:
Bring the total from a subreport onto a main report
at:
http://allenbrowne.com/casu-18.html

--
Allen Browne - Microsoft MVP. Perth, Western Australia

Reply to group, rather than allenbrowne at mvps dot org.

--
The bottom of my report which is a statement shows #Error when there is
no Invoices to add up. Can I have it blank instead. this my text Box
Control Source
thanks for any Help....Bob

=Reports!rptOwnerPaymentMethod!subChildOwnerInvoiceAmount!tbAmount.Value

 

[Allen Browne]

Try adding the ".Report" bit:
=IIf([subChildOwnerInvoiceAmount].[Report].[HasData],
[subChildOwnerInvoiceAmount].[Report].[tbAmount])

If that still fails, open the main report in design view, right-click the
edge of the subform control, and choose Properties. On the Other tab of the
Properties box, look at the Name property. Perhaps the name of this subform
control is different than the name of the report you load into it (its
SourceObject.)

--
Allen Browne - Microsoft MVP. Perth, Western Australia

Reply to group, rather than allenbrowne at mvps dot org.

Thanks Allen but got the #Name?......Bob

Try:
=IIf([subChildOwnerInvoiceAmount].[HasData],
[subChildOwnerInvoiceAmount].[tbAmount])

Explanation in:
Bring the total from a subreport onto a main report
at:
http://allenbrowne.com/casu-18.html

--
The bottom of my report which is a statement shows #Error when there is
no Invoices to add up. Can I have it blank instead. this my text Box
Control Source
thanks for any Help....Bob

=Reports!rptOwnerPaymentMethod!subChildOwnerInvoiceAmount!tbAmount.Value

 

[Bob]

Allen the
Name:subChildOwnerInvoiceAmount
control source:Report.rptSubOwnerInvoiceAmount
Thanks for the help.....Bob

Try adding the ".Report" bit:
=IIf([subChildOwnerInvoiceAmount].[Report].[HasData],
[subChildOwnerInvoiceAmount].[Report].[tbAmount])

If that still fails, open the main report in design view, right-click the
edge of the subform control, and choose Properties. On the Other tab of
the Properties box, look at the Name property. Perhaps the name of this
subform control is different than the name of the report you load into it
(its SourceObject.)

--
Allen Browne - Microsoft MVP. Perth, Western Australia

Reply to group, rather than allenbrowne at mvps dot org.

Thanks Allen but got the #Name?......Bob

Try:
=IIf([subChildOwnerInvoiceAmount].[HasData],
[subChildOwnerInvoiceAmount].[tbAmount])

Explanation in:
Bring the total from a subreport onto a main report
at:
http://allenbrowne.com/casu-18.html



--
The bottom of my report which is a statement shows #Error when there is
no Invoices to add up. Can I have it blank instead. this my text Box
Control Source
thanks for any Help....Bob

=Reports!rptOwnerPaymentMethod!subChildOwnerInvoiceAmount!tbAmount.Value

 

[Allen Browne]

So, I take it you have it working now with:

=IIf([subChildOwnerInvoiceAmount].[Report].[HasData],
[subChildOwnerInvoiceAmount].[Report].[tbAmount])

--
Allen Browne - Microsoft MVP. Perth, Western Australia

Reply to group, rather than allenbrowne at mvps dot org.

Allen the
Name:subChildOwnerInvoiceAmount
control source:Report.rptSubOwnerInvoiceAmount
Thanks for the help.....Bob

Try adding the ".Report" bit:
=IIf([subChildOwnerInvoiceAmount].[Report].[HasData],
[subChildOwnerInvoiceAmount].[Report].[tbAmount])

If that still fails, open the main report in design view, right-click the
edge of the subform control, and choose Properties. On the Other tab of
the Properties box, look at the Name property. Perhaps the name of this
subform control is different than the name of the report you load into it
(its SourceObject.)

Thanks Allen but got the #Name?......Bob

Try:
=IIf([subChildOwnerInvoiceAmount].[HasData],
[subChildOwnerInvoiceAmount].[tbAmount])

Explanation in:
Bring the total from a subreport onto a main report
at:
http://allenbrowne.com/casu-18.html



--
The bottom of my report which is a statement shows #Error when there
is no Invoices to add up. Can I have it blank instead. this my text
Box Control Source
thanks for any Help....Bob

=Reports!rptOwnerPaymentMethod!subChildOwnerInvoiceAmount!tbAmount.Value

 

[Bob]

Thanks Allen for the helping hand, much appreciated...bob

So, I take it you have it working now with:

=IIf([subChildOwnerInvoiceAmount].[Report].[HasData],
[subChildOwnerInvoiceAmount].[Report].[tbAmount])

--
Allen Browne - Microsoft MVP. Perth, Western Australia

Reply to group, rather than allenbrowne at mvps dot org.

Allen the
Name:subChildOwnerInvoiceAmount
control source:Report.rptSubOwnerInvoiceAmount
Thanks for the help.....Bob

Try adding the ".Report" bit:
=IIf([subChildOwnerInvoiceAmount].[Report].[HasData],
[subChildOwnerInvoiceAmount].[Report].[tbAmount])

If that still fails, open the main report in design view, right-click
the edge of the subform control, and choose Properties. On the Other tab
of the Properties box, look at the Name property. Perhaps the name of
this subform control is different than the name of the report you load
into it (its SourceObject.)

Thanks Allen but got the #Name?......Bob

Try:
=IIf([subChildOwnerInvoiceAmount].[HasData],
[subChildOwnerInvoiceAmount].[tbAmount])

Explanation in:
Bring the total from a subreport onto a main report
at:
http://allenbrowne.com/casu-18.html



--
The bottom of my report which is a statement shows #Error when there
is no Invoices to add up. Can I have it blank instead. this my text
Box Control Source
thanks for any Help....Bob

=Reports!rptOwnerPaymentMethod!subChildOwnerInvoiceAmount!tbAmount.Value

 

[i_takeuti]

Allen the
Name:subChildOwnerInvoiceAmount
control source:Report.rptSubOwnerInvoiceAmount
Thanks for the help.....Bob

Try adding the ".Report" bit:
=IIf([subChildOwnerInvoiceAmount].[Report].[HasData],
[subChildOwnerInvoiceAmount].[Report].[tbAmount])

If that still fails, open the main report in design view, right-click the
edge of the subform control, and choose Properties. On the Other tab of
the Properties box, look at the Name property. Perhaps the name of this
subform control is different than the name of the report you load into it
(its SourceObject.)

--
Allen Browne - Microsoft MVP. Perth, Western Australia

Reply to group, rather than allenbrowne at mvps dot org.

Thanks Allen but got the #Name?......Bob

Try:
=IIf([subChildOwnerInvoiceAmount].[HasData],
[subChildOwnerInvoiceAmount].[tbAmount])

Explanation in:
Bring the total from a subreport onto a main report
at:
http://allenbrowne.com/casu-18.html



--
The bottom of my report which is a statement shows #Error when there
is no Invoices to add up. Can I have it blank instead. this my text
Box Control Source
thanks for any Help....Bob

=Reports!rptOwnerPaymentMethod!subChildOwnerInvoiceAmount!tbAmount.Value