Please help with Correct query criteria

[aaron1riley]

Hi,

hoping someone can please help me with the filtering (navigation subform) of a split from im using. All controls i have to filter the form are working except for my final one which has an added control in form of a checkbox.

Using a Navigation sub form i would like to select a checkbox which when true only returns records which are not Null from the "Countremeasure" field (from the back end table ) and also only returns records for "Done" (yes/no field) if "No"
Then if checkbox isnt selected it returns everything.


Sorry for lack of info that you may need to help as i am a complete novice. Hoping for query criteria statement as im not into coding.

Thanks and appreciate your time


Aaron

[Bob Fitz]

Can you post a copy of the db

[aaron1riley]

Hi Bob, id like to but cant due to company policy. is there any other generic info i can give that can aid you?

[Micron]

Hard to see the criteria but it looks like True is wrapped in dbl quotes ("True") which is probably being interpreted as a text value, not as T or F. The "No " & in Done field looks wrong as well in that it's text again, and I can't imagine a checkbox field (Done) containing a string like No. Try removing the concatenation from each field as a start. Also, this seems contradictory: checkbox which when true only returns records which are not Null

yet you specify Null & in the Countermeasure field. If the criteria is True, then checking for anything else doesn't make sense.

[aaron1riley]

Hard to see the criteria but it looks like True is wrapped in dbl quotes ("True") which is probably being interpreted as a text value, not as T or F. The "No " & in Done field looks wrong as well in that it's text again, and I can't imagine a checkbox field (Done) containing a string like No. Try removing the concatenation from each field as a start. Also, this seems contradictory: checkbox which when true only returns records which are not Null

yet you specify Null & in the Countermeasure field. If the criteria is True, then checking for anything else doesn't make sense.

Thanks for your help, your suggestions aided my solution.

[Micron]

Glad I was able to assist somehow.