just to note: am using Access 2000 forms and reports and database for this,
i.e. VBA

Gill

"Gillian Maloney" <GMaloney@pbs.ie> wrote:
>
>Hello,
>I have a form which has a number of check boxes on it representing fields
>from a number of tables.
>The user clicks on the check boxes representing the fields they want to
view
>in a report.
>I get to this part fine and I can open a report using the Createreport function,
>but what I want to do is open a report in Run-time view and not in Design-view
>and I have also been unsuccessful in opening the new report in template
format.
>createreport(,templatename)
>
>
>Can anyone tell me if it is possible to open a report with all the fields
>the user has picked on it, and not just in design view with the fields in
>a list yet to be put onto the form.
>
>I hope I have explained my query correctly, if you need any more information
>to understand what I need, just ask!
>Thanks so much for this sites continued help to me!
>
>Regards
>Gill
>