Dlookup Error On Form When Using Query Result In Unbound Field

[Diko83]

Hi all,
I've been looking fruitlessly on the net for a while and can't really find a solution to my error.

I'm creating a database for home loans and want to show in the individual staff forms the total values for each stage that loans are at.

Related tables and queries in this scenario are Loan Status, Applications, Staff Name and Totals Filter.

The three items in the query are: BB Number (the Staff Number), Loan Status and Sum of Loan Value. The totals filter is setup to only show data for that particular staff member on the open form. This has been done by using the condition for BB Number: [Forms]![Pipeline]![BB Number] where Pipeline is the form I am referring to and BB Number is the staff number.

Because the staff have already been filtered, I just need to get the totals for the stages that the loans are at. If I try to show totals of loans done by this staff member at Conditionally Approved Stage, I am using =DLookUp("[SumOfLoan Value]","[TotalsFilter]","[TotalsFilter]![Loan Status]"=5) where Loan Status = 5 is the Primary Key Value for Conditionally Approved.

I keep getting a #error message. Any clues as to where I am going wrong? Any help is greatly appreciated.

 

[PHV]

Perhaps this ?
=DLookUp("[SumOfLoan Value]","TotalsFilter","[Loan Status]=5")

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886

 

[Diko83]

Perhaps this ?
=DLookUp("[SumOfLoan Value]","TotalsFilter","[Loan Status]=5")

Thanks PHV, but unfortunately I'm still getting the exact same error. :-(

 

[Diko83]

Actually, it's working now.

BRILLIANT!!!

Thanks again.