Option group problem

[wrekless]

Hi, on my form I have an option group(Frame2) with two possible options, corresponding to values 1 and 2.
The form is linked to a query and there is a command button that runs this query.

In the query, under the criteria field for 'Printed', which is a Yes/No Data Type, I have:

IIf([Forms]![Form Printed Or Not]![Frame2]=1,[Printed]=-1,[Printed]=0)

I'm trying to get the query to display all the printed records if that option is selected. It's not happening

[This message has been edited by wrekless (edited 06-28-2000).]

 

[Carol]

In the criteria line for your Printed field in your query, just state "Yes" this will return all records that have been printed.

[This message has been edited by Carol (edited 06-28-2000).]

 

[wrekless]

I want the user to be able to view selected records that have been printed, or records that haven't been printed.