Hello,
I have a query having criteria reference from Form objects.  For Example, In Query Design column, ReceiveDate criteria has >=[Forms]![Frm_C_NewPatient_Annotation_WorkList]![txt_FromDate_Search].[Value] And <=DateAdd("d",1,[Forms]![Frm_C_NewPatient_Annotation_WorkList]![txt_ToDate_Search].[Value])  This works great.
In another Query Design column called, LockedUser i can insert Is Null in Criteria to query records having LockedUser is Null.  Now, i want to change Is Null and instead reference a checkbox that i can toggle back and forth between Is Null and Is Not Null.  Having trouble with this.  I just learned that IIF in criteria can not reture Is Null or Is Not Null. I also tried referencing a Public Function from My criteria but, couldn't get that to work.  Can someone assist with my issue?
Thank You, David Garcia,
Houston, TX