I have an Iif in a column on the query:
Code:
B1: IIf(([Disposition]=4),"Remove from Pending/")
The Disposition field on my main table (tblConsultData) pulls it's selectable values from another table (tblConsultDispositions). When I try to do this statement it returns an #ERROR in the field. I can make this work with fields that don't have a Combo Box pulling values from another table, but in the query it loads the values of the Disposition field as a number value to reflect this (4, for example instead of 'Scheduled' which is what the 4 value represents). Any idea how to make this work?