Things I see......
Code:
=DLookUp("[Base Chase Price]","[DT Pricer]","[Loan Id] =" & form![txtLoanID] & " And [Rate] = " & form![txtRate] & “ And [Security Month] = " ‘& Form![txtDeliveryMonth] & ‘“ And [Trade Date] = " & Form![txtTradeDate] & “ And [Coupon] = " & Form![txtCoupon])
You are mixing up double quotes (") and two single quotes ('')
You have a triple single quote
You have a single quote in the wrong place.
Compare the above with this:
Code:
=DLookUp("[Base Chase Price]","[DT Pricer]","[Loan Id] =" & form![txtLoanID] & " And [Rate] = " & form![txtRate] & " And [Security Month] = '" & Form![txtDeliveryMonth] & "' And [Trade Date] = " & Form![txtTradeDate] & " And [Coupon] = " & Form![txtCoupon])
You don't have "Delivery Month" field in the expression.
Is the value from "Security Month " = Form![txtDeliveryMonth]??
Also, if [Trade Date] is a date, then dates must be delimited with the hash sign (#)
ex.
Code:
<snip> & "' And [Trade Date] = #" & Form![txtTradeDate] & "# And [Coupon] = <snip>