#Name? Error

[jlokenvitz]

I am working on creating a database to track the contracts for my department, including all modifications and invoices as well as how much is left to pay on each contract. I have run into a problem, however. I have a query (UnobligatedQuery) with fields Contracts_ContractNumber, TotalAmount, TotalInvoiced, and Unobligated. I have a form called Contracts Query with fields ContractNumber (unbound dropdown list that pulls data from a query), DateAwarded, DeliveryDate, CCageCode, Status, StatusDate, PRNumber, PONumber, InitialAmount, SumOfFundingChange, TotalAmount, and Unobligated. This form also has a couple subforms but they are working fine.

The issue is with the Unobligated field in the form. I tried linking it directly to the Unobligated field in UnobligatedQuery but keep getting the #Name? error. I did some google searching and found a IIF formula (=IIf(IsNull([TotalAmount]-[Invoices Query]![TotalInvoiced]),0,([TotalAmount]-[Invoices Query]![TotalInvoiced]))) that is supposed to work in this situation but I get the same results. Any and all help with this situation is appreciated.

I am sure that the solution is something very simple that I am missing. Also, I was looking around to try to figure out how to attach the database to this post to help the troubleshooting but have not found how to insert anything other than pictures and video. I can email the database to someone if that will help. Thank you all in advance for your help.

 

[austenr]

You need to use If IsError before your IIf statement.

 

[jlokenvitz]

I included that in the syntax, with the new statement being =If(IsError(IIf(IsNull([TotalAmount]-[Invoices Query]![TotalInvoiced]),0,([TotalAmount]-[Invoices Query]![TotalInvoiced])))). I am still getting the #Name? error. Any other ideas?

 

[austenr]

try this:
you need to add the parameters that go with the Is ERROR. You have to tell it what to do. for example, I use "",0. That way it will get rid of the #NAME and set it to blank else it would set it to 0 if the #NAME was not there.

 

[Micron]

This error is often caused by the inability to resolve a reference to a field or control name. From what I read, your control Unobligated has the same name as your query field, which will cause this Error. Try renaming your control (probably better) or assigning an alias to your query field name. Your control names usually get the same name as your fields when you use a form or report wizard.