How do I program an option button or a Check Box Object

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

Guest

How do I program an option button or a Check Box Object when selected in a
form to display a record in one report, and if not selected display record in
a different report? If you could include a sample code of this it would be
greatly appreciated.
Thanks,
Rusty
 
How do I program an option button or a Check Box Object when selected in a
form to display a record in one report, and if not selected display record in
a different report? If you could include a sample code of this it would be
greatly appreciated.
Thanks,
Rusty
Click to expand...

Add a Yes/No Check box field to your table.
Then add the field to your form.
Place a check mark in any record you wish to show in a report.

You can then create a query to use as the report's recordsource.
As criteria on the Yes/No field, write either:
-1 to just show the records that have been checked
or:
0 to just show the records that have not been checked.
 
Thanks so much fred that sounds like what I need
fredg said:
Add a Yes/No Check box field to your table.
Then add the field to your form.
Place a check mark in any record you wish to show in a report.

You can then create a query to use as the report's recordsource.
As criteria on the Yes/No field, write either:
-1 to just show the records that have been checked
or:
0 to just show the records that have not been checked.
Click to expand...
 
Back
Top