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


"Gillian Maloney" <GMaloney@pbs.ie> wrote:
>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

>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

>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!