Dsum invalid bracketing error

[MaryRod]

I have this Dlookup query and it is giving me an error 2471 invalid bracketing for the field "[Tbl_Loan_Info.Tbl_Borrower_ID]

AnnualLoanPayment = DLookup("Tbl_Loan_Info.Tbl_LInfo_Annual_Loan_Payme nt", "QryAnnualLoanPayment", "[Tbl_Loan_Info.Tbl_Borrower_ID] =" _


& Me.Tbl_Financial_Customer_ID & " And[Tbl_Loan_Info.Tbl_PropertyInfo_ID] = " _
& Me.Tbl_FPropertryInfo_ID)

MsgBox AnnualLoanPayment & "payment"


The Borrower_ID is numeric

[orange]

Please show the SQL view of "QryAnnualLoanPayment".
Is there really a space in this?
"Tbl_Loan_Info.Tbl_LInfo_Annual_Loan_Payme nt",

[MaryRod]

SELECT Tbl_Loan_Info.[Tbl_Borrower_ ID], Tbl_Loan_Info.Tbl_PropertyInfo_ID, Tbl_Loan_Info.Tbl_LInfo_Annual_Loan_Payment, Tbl_Tax_Return.Tbl_Tax_Return_Year
FROM Tbl_Loan_Info INNER JOIN Tbl_Tax_Return ON (Tbl_Loan_Info.[Tbl_Borrower_ ID] = Tbl_Tax_Return.Tbl_Borrower_ID) AND (Tbl_Loan_Info.Tbl_PropertyInfo_ID = Tbl_Tax_Return.Tbl_Tax_Return_Property_ID)
WHERE Tbl_Tax_Return.Tbl_Tax_Return_Year = (SELECT MAX(Tbl_Tax_Return.Tbl_Tax_Return_Year) FROM Tbl_Tax_Return);

[MaryRod]

There is no space in "Tbl_Loan_Info.Tbl_LInfo_Annual_Loan_Payme nt", It shows a space after copy and paste

[pbaldy]

See if this works

[Tbl_Loan_Info].[Tbl_Borrower_ID]

[MaryRod]

Not it did not work. It still gives me the same error

[MaryRod]

Run-Time error 2471
The expression you entered as a query parameter produced this error: '[Tbl_Loan_Info].[Tbl_Borrower_ID]'

[orange]

I agree with Paul, I think you either have no square brackets or have them around each part.

[orange]

Try taking all of the [ and ] out of your SQL. Try this.

AnnualLoanPayment = DLookup("Tbl_Loan_Info.Tbl_LInfo_Annual_Loan_Payment", "QryAnnualLoanPayment", "Tbl_Loan_Info.Tbl_Borrower_ID =" _
& Me.Tbl_Financial_Customer_ID & " And Tbl_Loan_Info.Tbl_PropertyInfo_ID = " _
& Me.Tbl_FPropertryInfo_ID)

[MaryRod]

If I remove the brackets I get the same error. I have no idea and do not understand.

The one below works perfectly:

CashFlow = DLookup("[Tbl_Tax_Return.Tbl_Tax_Return_NetCashFlow]", "QryNetCashFlow", "[Tbl_Tax_Return.Tbl_Borrower_ID] =" _
& Me.Tbl_Financial_Customer_ID & " And [Tbl_Tax_Return.Tbl_Tax_Return_Property_ID] = " _
& Me.Tbl_FPropertryInfo_ID)
MsgBox CashFlow & "cashflow"

[MaryRod]

I copied and pasted the code and still gets the Run-time 2471 error.The expression you entered as a ....

[MaryRod]

Got it to work. I changed the query to

SELECT Tbl_Tax_Return.Tbl_Borrower_ID, Tbl_Loan_Info.Tbl_PropertyInfo_ID, Tbl_Loan_Info.Tbl_LInfo_Annual_Loan_Payment, Tbl_Tax_Return.Tbl_Tax_Return_Year
FROM Tbl_Loan_Info INNER JOIN Tbl_Tax_Return ON (Tbl_Loan_Info.Tbl_PropertyInfo_ID = Tbl_Tax_Return.Tbl_Tax_Return_Property_ID) AND (Tbl_Loan_Info.[Tbl_Borrower_ ID] = Tbl_Tax_Return.Tbl_Borrower_ID)
WHERE (((Tbl_Tax_Return.Tbl_Tax_Return_Year)=(SELECT MAX(Tbl_Tax_Return.Tbl_Tax_Return_Year) FROM Tbl_Tax_Return)));

then I changed the code to

AnnualLoanPayment = DLookup("Tbl_Loan_Info.Tbl_LInfo_Annual_Loan_Payme nt", "QryAnnualLoanPayment", "[Tbl_Tax_Return.Tbl_Borrower_ID] =" _
& Me.Tbl_Financial_Customer_ID & " And Tbl_Loan_Info.Tbl_PropertyInfo_ID = " _
& Me.Tbl_FPropertryInfo_ID)
MsgBox AnnualLoanPayment & "payment"

Thanks for your help