Expression Problem in Form

  • Thread starter Thread starter legal_eagle_01
  • Start date Start date
L

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?
 
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
 
Back
Top