Form coding/process question

[Guest]

I have a form that has three radio buttons for Specialty:
1)Cardiology
2)Pediatrics
3)General Surgery

Based on the Specialty that is selected the user can then pick from
additional radio buttons for the reports they would like to view. How do I
tell my form to only show the report for the selected Specialty when
displaying up the reports.

I am currently writing this sql as an Event Procedure that is linked to a
module when the user clicks the View Reports button.

Thank you for any assistance!!!
JZ

 

[pietlinden]

I have a form that has three radio buttons for Specialty:
1)Cardiology
2)Pediatrics
3)General Surgery

Based on the Specialty that is selected the user can then pick from
additional radio buttons for the reports they would like to view. How do I
tell my form to only show the report for the selected Specialty when
displaying up the reports.

I am currently writing this sql as an Event Procedure that is linked to a
module when the user clicks the View Reports button.

Thank you for any assistance!!!
JZ

one way might be to use checkboxes for Specialty, and then populate a
listbox of reports that meet those criteria. Just rebuild the filter
part of the SQL and requery the listbox.