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