Multiple checkboxes to filter report (1 Viewer)

[tabitha]

I have a form where you can select four different options: Health, Dental, Vision, and COBRA, with a button to run a census. Right now, the button runs a DoCMD.OpenReport to open a report named "Census" where there are four text boxes, "Health Coverage Type" "Dental Coverage Type" "Vision Coverage Type" and "COBRA Coverage Type". I want the user to be able to select a checkbox, then filter the report to only enable the text boxes of the corresponding names.

So if someone selects Health & Dental, I want the report to run with the "Health Coverage Type" and "Dental Coverage Type" textboxes enabled/visible, but the other two to be blank.

Any ideas??

 

[Mihail]

Put a bit of code in the report Open event:

Me.TxtBoxName.Visible = Forms!FormName.CheckBoxName

Do this for each textbox in your report.

I think that your report will become ugly because the blank spaces