>I am trying to build a controlsource for a checkbox that will work with two different possible sets of tables.
>
>IIF([type(empdrvr.callboard) = "L"], empdrvr.callboard, IIF([empdrvr.callboard = 1], .T., .F.))
Sure, the brackets are interpreted as quotation marks.
Change this:
iif([...
to this:
iif(...)
By the way, the second iif() is superfluous, just return
empdrvr.callboard = 1, which is already true or false.
This reduces the entire epxression to:
IIF(type(empdrvr.callboard) = "L", empdrvr.callboard, empdrvr.callboard = 1)
Difference in opinions hath cost many millions of lives: for instance, whether flesh be bread, or bread be flesh; whether whistling be a vice or a virtue; whether it be better to kiss a post, or throw it into the fire... (from Gulliver's Travels)
