Simple Checkbox Query has me stuck?

[mikelev]

Access 2000

I have a form CLIENT with a field named 'DENY' which is a checkbox on a table named CLIENT. I am writting an Access report to show all clients that have a check in the DENY field.

Should I use a query, or can that parameter be set in the ControlSource section?

Any help would be appreciated.

 

[glalsop]

You don't need to create a query if you only want to limit the records on your table by one field on a single table.

You could add a button to your form, and use the Where parameter of the DoCmd.OpenReport method:

DoCmd.OpenReport "YourReport",acViewPreview,,"DENY = true"

-Gary

 

[mikelev]

Thanks Gary worked perfectly!