DLookup problem

[Alimonti.Nicole]

I'm trying to create a query that shows many loans and lots of
information about the loans. This query should be fed from a master
loan table that shows the initial input about each loan and then
another query that shows the updates for each of these loans. In other
words, I have to add two numbers, one from a table and a one query.
Here is the code I have and error message I receive.

iif([Syndication?]="Yes",
[TotalBLBCommitment]+DLookup("[FutureCommitments]", "Syndications",
"[FacCode]=Queries![Syndications]![FacCode]"),0)

The error message says: The expresion you entered as a query parameter
produces this erorr: 'Microsoft Office Access can't find the name
'Queries!Syndications!FacCode' you entered in the expression'

 

[Jeff L]

Is this query running off another query called Syndications? If so
then you need to change "[FacCode]=Queries![Syndications]![FacCode]" to

"[FacCode] = " & [Syndications].[FacCode] in your DLookup.

Sorry if I'm not clear on what you're doing.