User selection of Fields for a report

  • Thread starter Thread starter Irina
  • Start date Start date
I

Irina

I have a form that has check boxes of the fields that user can select
so those fields appear on the report.
I have a report that has all the fields in it. I am not sure what to do next
and what
to add in the code of the report or code in the form to make this work.
Basically, the users want to specify the fields that they want to see on the
report
and then run the report, preview it in excel and export it to an excel.
I know that this can be done, but not sure exactly how.
Do I add all the checkboxes fields into the table that controls the report
data?
please advise
 
I have added checkboxes to the report table and made all the fields
not visible in the report
here is part of the code I have
in the report section
Private Sub Detail_Format(Cancel As Integer, FormatCount As Integer)

If chkIndividual.Value = vbChecked Then
Employee_Label.Visible = True
Else
Employee_Label.Visible = False
End If

can anyone please help with this?
 
Back
Top