Expression Problem in Form

[legal_eagle_01]

Hi; the following expression worked fine while running my database
under OfficeXP:

=[Forms]![fCasesRev]![fsCasesRevNoEscrow].[Form]![CaseBalance]

where CaseBalance is defined as:

=Sum([Amount]+([HourlyRate]*[TimeSpent]))

Now, I get nothing.... The CaseBalance fails to display in the form.
Does anyone see anything wrong with either of these expressions?

 

[Jeanette Cunningham]

Hi,
One thing I notice is that fsCasesRevNoEscrow looks like the name of a form
that would be in a subform control.
The expression needs to be like this:
= [Forms]![FormName]![Name of subform control].[Form].CaseBalance
and the form called fCasesRev needs to be open when you use the expression.

Try the above.

Jeanette Cunningham