=DLookUp("[CIMPROV<1200]","[CALCSTANDARD]","[GRADE]=" & [Forms]!APPRAISERPRODUCTION!GRADE2)
Spot the typo. A quick point: With the grade2 textbox with a controlsource equal to 2 (in other words, it uses a field called 2 on a bound form), why not just set the criteria clause of Dlookup to pick up values where grade=2?
For example:
=DLookUp("[CIMPROV<1200]","[CALCSTANDARD]","[GRADE]=2")
If you meant to have a value of 2 in the box, set the controlsource to blank and the default value property to 2.
John