Setting properties for check boxes

O

Old Bethel

I'm trying to run a query using a newly created check box. I pasted the
properties from an existing check box so they would function the same way.
The criteria that works on the original is "yes" or "no". I can't get that
to work with the new text box. Any suggestions?
 
M

Maurice

Indeed hard if you don't post your query. You are referring to checkboxes and
textboxes. Is the field which you put your criteria ("yes" or "No") on a
textfield or a yes no field. Depending on the datatype you could use:

True - False, -1 - 0, yes - no (without parentheses) for checkboxes and
"yes" - "No" for textboxes assuming that is the text that can be entered.

Try some and let us know (in that case post the query).

Maurice
 
Top