IIF in Control Source
Posted on 2007-10-16
I have an IIF statement in a control source for X. Statement is as follows: (I have not considered the 'False' part of the statement yet, so ignore that)
=IIf([PrevCurHold]=2,DLookUp([Finalized],[qryCurYearFormFill],[TruckID]=105 And Month([MonthYr])=7),"False statement here")
Basically trying to lookup the value of "Finalized" in my query Where "TruckID" = 105 and the Month of "MonthYr" = July, but not sure how to write the code for the IIF statement. What I have does not work obviously.
Thanks for any help