Parameter Checkbox

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a query that takes several criteria from a form. I place a check box
on the form with the intend to display all records that are true when check
and list all available record if uncheck The query is providing all available
record when the check box is check/or uncheck. Please help me with writing
the correct criteria for a parameter checkbox. I am working with Access 2003.
 
Try this

DoCmd.OpenReport "ReportName", , , "[CheckBoxFielName] =" &
Nz(Me.[CheckBoxFileldNameInTehForm], 0)

Incase no value is selected it will replace the Null with 0
 
Josh,

Assuming your checkbox's selection applies to a field of Yes/No data
type... In the criteria of the query, put the equivalent of this...
[Forms]![YourForm]![YourCheckbox] Or [Forms]![YourForm]![YourCheckbox]=0
 
Back
Top