Query Question (new access user)

[lewismk]

I am brand new to access and trying to run a query. I was able to setup a form with a yes/no question box. Once I click this box, I would like the form to tell a query to run the "yes" value. I am struggling how to get the query to read the yes check box. I have the criteria set as [Forms]![form name]![field name]. Can someone please help?

[ajetrumpet]

Forms]![form name]![field name]

is the correct reference syntax so your problem must be with the statement.

[NTC]

not sure how you've set up the form. an unbound control? a check box with a check in it = -1

if you manually put -1 into the query would it work? probably the query is literally looking for 'yes' ....not clear from your post as it depends on what the table field is set up for and the form control - - but to make it work these two must match.

Hope this helps you get going in the right direction.