Option Button?

[Guest]

I made a simple database for Invoice Payments to some Supplier. I made a
button which opens a report Between 2 chosen dates but I'd also like to have
the options to show me all invoices or to show me only the Invoices with the
value unpaid >0.
I thought of some option button but i really don't know how to make it.
Ty very much for help,
Diana

 

[Jeff Boyce]

It sounds like you are trying to come up with a way to select which report
to run, or perhaps how to "parameterize" a single report.

Another approach would be to use a "report order" form that holds controls
for the selection of the parameters, generates a SQL WHERE clause on the
fly, based on the parameters selected, then opens the report using the WHERE
clause. Note that this approach could also work if you included a list of
the available reports in a combo box, and had your <Print Preview> command
button open the report selected in the combo box.