you might try putting all the fields on the report
and then in the 'OnFormat' event control a field's visibile state dependent
on the fields in the Form
rough test it with just one....not sure if the Form has check boxes or radio
buttons or text buttons or what.... depending on your version you might have
to research the value representing the control...
If Forms!FormName.CheckBox=Yes then
me.ReportField.Visible=True
End If
Could be very burdensome and crude if there are lots of fields to
control....possibly you can cluster/group them into separate subReports and
make the entire subReport visible or not.....
very sloppy advice...sorry.....

Signature
NTC
> Is there a way to allow users select the fields that they want in a report
> via a form check boxes or radio buttons?
[quoted text clipped - 4 lines]
>
> please help
Irina - 20 Feb 2008 14:45 GMT
thank you very much I will give that a try
> you might try putting all the fields on the report
>
[quoted text clipped - 23 lines]
> >
> > please help
Not exactly what you are asking for, but you might take a look at
The demo available at
http://www.rogersaccesslibrary.com/OtherLibraries.asp#Hookom,Duane.
DH Query By Form
You can add the
functionality to any application by
-importing several forms and 2 tables into your app
-creating one or more "master" queries with names like
<Employee Work>
<Clients>
All query/reports are saved in the two tables. Results of the queries are
displayed in a datasheet subform on a main form with option buttons to send
to print, Word Table, text file, csv file, Excel, Html...

Signature
John Spencer
Access MVP 2002-2005, 2007-2008
Center for Health Program Development and Management
University of Maryland Baltimore County
.
> Is there a way to allow users select the fields that they want in a report
> via a form check boxes or radio buttons?
[quoted text clipped - 5 lines]
>
> please help
Irina - 20 Feb 2008 14:44 GMT
Thanks guys, I will give that a try and get back if I have any questions.
> Not exactly what you are asking for, but you might take a look at
>
[quoted text clipped - 21 lines]
> >
> > please help