M
MSA
I have a text box-(MainForm) that is reading a value from a subtotal text
box-(subform) from a subform.
When the form is opened initially it always has an "#Error" in this text
box-(MainForm) as a result of subtotal on the subform not having a value to
sum, thus causing the error.
So I tried using the following code in the Control Source property of my
text box-(MainForm) but I keep getting an error message "saying the
expression you entered contains invalid syntax".
=IIf([x_F_Area subform].[Form].[RecordsetClone].[RecordCount] = 0, 0,
Nz([x_F_Area subform].[Form].[Text10],0))
Would appreciate if someone could point out where the above expression is
wrong.
Thanks!
box-(subform) from a subform.
When the form is opened initially it always has an "#Error" in this text
box-(MainForm) as a result of subtotal on the subform not having a value to
sum, thus causing the error.
So I tried using the following code in the Control Source property of my
text box-(MainForm) but I keep getting an error message "saying the
expression you entered contains invalid syntax".
=IIf([x_F_Area subform].[Form].[RecordsetClone].[RecordCount] = 0, 0,
Nz([x_F_Area subform].[Form].[Text10],0))
Would appreciate if someone could point out where the above expression is
wrong.
Thanks!