#error in calculated textbox that references subform

Hi. In Access 2007 I have an unbound textbox (called txtTotal) on the main
form that calculates a value. The ControlSource of txtTotal is an expression
that subtracts a field on the subform from a field on the main form. When
the subform has no records then the txtTotal says #error. It looks bad and
also causes an error of "expression has no value" in my code.

Help? Thanks!!

See:
Avoid #Error in form/report with no records
at:
http://allenbrowne.com/RecordCountError.html

The article explains how the expression we commonly used in previous
versions fails in A2007, and suggests using a VBA function to return the
value as the expression works there.

--
Allen Browne - Microsoft MVP. Perth, Western Australia
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

"Very Rusty User" Very Rusty wrote in
message
...
Hi. In Access 2007 I have an unbound textbox (called txtTotal) on the
main
form that calculates a value. The ControlSource of txtTotal is an
expression
that subtracts a field on the subform from a field on the main form. When
the subform has no records then the txtTotal says #error. It looks bad
and
also causes an error of "expression has no value" in my code.

It worked! Thank you SO VERY much! I really appreciate your help.