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 http://www.access-programmers.co.uk/ubb/frown.gif

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

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).]

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