sub form problems

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

=Pmt(InterestRate/12,term*12,-Amount,0,0)is the formula I am using to compute
the Payment Due in a loan subform but whenI view the form the form has
#name? where the payment is supposed to be. What am I doing wrong???
 
usually, the #Name? display signifies that Access cannot identify one or
more of the fields referenced in the expression. double check each field
name that you're using in the Pmt() function, make sure that each field is
included in the form or report RecordSource, and make sure that the control
in which you placed the function does not have the same name as any of the
referenced fields.

hth
 
Back
Top