Producing a report via a custom dialog box (1 Viewer)

[Everton]

Im having difficulty in using check boxes in a custom dialog box, to set up the parameters in a query. I then want to produce a report from this query. Can this be done, and if so does anybody have any advice?

 

[Pat Hartman]

Check boxes have three possible values
True = -1
False = 0
Null = null

Try setting the default value to 0 to eliminate the null possibility.

Use the query as the recordsource for the report and run the report not the query from your dialog box.