check boxes within a query - criteria yes/no

[Guest]

Hi, I've created a form from a query. When a button is pressed, a question
is run regarding the check box field, being 'Is the student enrolled - 'yes'
or 'no' , the user should enter 'yes' or 'no' (without the commas' to run the
query with the correct information chosen, currently only working with -1 or
0, which users won't know. How do I resolve and get the 'yes' and 'no'
working ?
Cheers
Cheryl

 

[John W. Vinson]

Hi, I've created a form from a query. When a button is pressed, a question
is run regarding the check box field, being 'Is the student enrolled - 'yes'
or 'no' , the user should enter 'yes' or 'no' (without the commas' to run the
query with the correct information chosen, currently only working with -1 or
0, which users won't know. How do I resolve and get the 'yes' and 'no'
working ?
Cheers
Cheryl

Use

=[Forms]![YourFormName]![Checkboxname]

as a criterion for the query rather than making the user reply to a MsgBox.

John W. Vinson [MVP]