[access 2002] - report generation

[creativefusion]

Hi All,

I have a fully interactive 2002 ADODB driven database with 5 reports attached to parameter queries.

I have a form called "UF_REPORT_SELECTION" with a combo box named CboReport.

In simple terms, I want to allow my user to do the following:

1. Select any of the five reports from the combo box
2. Enter the required parameters
3. Run the report and display in preview mode

Any suggestions?

Your help is appreciated.

Regards,
CF

 

[gemma-the-husky]

so what can you not do?

you need to standardise the parameters - wither with gbl variables, or form variables

then on a button click you can just do

docnd.openform cboreports, acpreview (or something similar)

you may need cboreports.column

depending on how you manage the combo box.

 

[creativefusion]

Hi,

Thanks for the advice.

I am struggling with the following:

1. How do I fill the combo box with the list of reports
2. How do I collect the parameters for the query attached to the reports

On item 2, the reports are based on 1, 2 or 3 reference numbers. So, when the user clicks view report, the system then prompts the user to enter their reference numbers of choice. If the user only enters one, then the report returns the data for one reference. Else, if the user enters three numbers, the report returns data for three references.

Thanks again.

CF