dynamically allow user to store data in multiple forms

[thesky1988]

Hi,



I have a access program where it has the following 4 tables.

Reports - List of all available reports
Requests - List of all requests to run a given reports
Parameters - List of all parameters needed to run the report
RequestDetails - A history table which stores all the parameters which was used previously

Relationship:
1 report can have many requests
1 requests can have many parameters

I want to do the following...
There is a run button in the program where, when clicked, it should open up a request form which has two tabs.

First tab - Request Data - A subform which allows user to complete data to be put into the "Requests" table
Second tab - Request Data - A subform - datasheet format which allows user to enter all the parameters (stored in RequestDetails) needed for this report

Example...
Report 1 needs 2 parameters to run - (Start Date, End Date)

If someone wants to run report 1, they have to enter some basic information on tab one (requested by who? when was it requested, etc...)
On tab two, they will have to enter the parameters going to be used to run the report (Start Date, End Date).

But i'm not sure where to start... can anyone help? I have attached my access file...

Thanks

[ranman256]

You need the form, that has all these boxes.
before you run the report, run a qry to post the vital info,
then open the report where the qry uses the params in the form dates.