I'm attempting to build a crosstab query that references fields on a form as criteria for my query. I have no problem referencing a combo box as part of my criteria -- the query likes that fine. However, when I attempt to reference a check box (ex. iif(Forms![CheckBox] = true, "A", "B"), I get the following error:
The Microsoft Jet database engine does not recogine '[Forms]![frmMyForm]![Check100]' as a valid field name or expression.
Anyone have any ideas why I can not reference a checkbox but I can other types of fields in my crosstab query?
Thanks in advance!
The Microsoft Jet database engine does not recogine '[Forms]![frmMyForm]![Check100]' as a valid field name or expression.
Anyone have any ideas why I can not reference a checkbox but I can other types of fields in my crosstab query?
Thanks in advance!