Need Help With DLookUp Function in Access 2010

[fmartz]

How can I put an IFF statment after [PSI_RTS] <=84 to subtract -2 days and if > 84 than subtract -3 days, 84 being the primary key.
Private Sub Text195_Click()



Text195 = DLookup("[BLDCED_Cur]", "TAB_LM6000", "[PSI_RTS]=forms![frmMaster_addLM6000]![PSI_RTS]-2")

End Sub

Text195-Main Assy ST [BLDCST_Cur] is the event code to subtract 2 days.
Text189-Main Assy End [BLDCED_Cur]
TAB_LM6000 - Table
[frmMaster_addLM6000]-Form
[PSI_RTS]-Text271 primary Key 84

[June7]

Why are you using the Click event of a textbox to set its value?

Variables must be concatenated into an expression. Reference to control is a variable.

Text195 = DLookup("[BLDCED_Cur]", "TAB_LM6000", "[PSI_RTS]=" & Forms![frmMaster_addLM6000]![PSI_RTS] & IIF(Forms![frmMaster_addLM6000]![PSI_RTS]>84,-3,-2))

[fmartz]

Thank you so much, that worked great.