Can the choose function be used with a checkbox when doing a query by form? I would like to use a triple state check box (to query a yes no field) and have all values returned if the check box is greyed.
The field I need to bring in is called resolved. It is a yes no field. I am trying to do a query by form where resolved is one of the choices. Sometimes the user would not know what value this field has. I have tried asking if this will work with nz but received no replies. I suspect when I submit this for review I will be asked to use a check box and not an option group, so I am trying to work this out ahead of time...
Attached are some screen shots so you can see what I am trying
my SQL is here:
SELECT Sheet1.full_account, Sheet1.name, Sheet1.telephone, Sheet1.due_dt, Sheet1.note1, Sheet1.resolved
WHERE (((Sheet1.due_dt)>=nz([Forms]![Form1]![Due Date],"1/1/1965")) AND ((Sheet1.note1) Like "*" & nz([Forms]![Form1]![Text0],"*") & "*") AND ((Sheet1.resolved)=Choose([Forms]![Form1]![Frame11]+2,True,False,[resolved])));
I do not know VBA but I am happy to try with some direction. I have only been using Access since December, so I am a beginner.