Selecting specific rows in a table that appear in a report

[BWG3]

Is there a way to use an option button or something in form that when selected, the table row of the form will not appear when a report is run on that form? Ex. There are two option buttons: "open" an closed" When a report is run on the form, only the rows with the field that has "open" selected will appear in the report. Thanks in advance.
Brandon

 

[ajetrumpet]

Is there a way to use an option button or something in form that when selected, the table row of the form will not appear when a report is run on that form? Ex. There are two option buttons: "open" an closed" When a report is run on the form, only the rows with the field that has "open" selected will appear in the report. Thanks in advance.
Brandon

you may have to run a query based on the option value, then base your report off of that.