If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
sub form problems
=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??? |
#2
|
|||
|
|||
sub form problems
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 "2spiritsin1" wrote in message ... =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??? |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Form won't open report from preview button | jwr | Using Forms | 5 | October 29th, 2005 04:53 PM |
using combo boxes with Filter by Form | baconroll | General Discussion | 3 | October 28th, 2005 04:23 PM |
Tell if Form is a Dialog | Alex | Using Forms | 7 | August 30th, 2005 06:22 PM |
Requerying a pop up form to display in the main form | Jennifer P | Using Forms | 13 | April 5th, 2005 06:59 PM |
auto entry into second table after update | Tony | New Users | 13 | July 9th, 2004 10:42 PM |