PASSING DIFFERENT CONTROLSOURCE TO ONE REPORT

[Angelique]

In an effort to reduce the size of my database, I had hoped to assign different queries depending on the user's response to the same report. A suggestion to use a form that would allow the user to select the desired report.

Could someone enlarge on this suggestion? A sample always goes a long way.

Thanks in advance.

Angelique

 

[MichaelRed]

Well,

No sample here, and while there are ways to assign different recordsources to a form, I much prefer to simply create a single query as the recordsource - but the only thing this query does is select the 'real' datasource for the form.

Basically, you will always need to 'know' which (of the several) queries you intend to use, and they all need to have all of the fields used in the form. Call the canidate queries "qry1", "qry2", ... "qryN" call the recordsource query qryReal.

In the selection procedure:

Select case YourSelectionCriteria
[tab]Case CriteriaForQry1
[tab][tab]qryReal.Sql = "Select * from Qry1;"

[tab]Case CriteriaForQry2
[tab][tab]qryReal.Sql = "Select * from Qry2;"

[tab]Case CriteriaForQry3
[tab][tab]qryReal.Sql = "Select * from Qry3;"

other selections

End Select

There are some details, so the above is NOT an example, just a 'starting point'.



MichaelRed
redmsp@erols.com

There is never time to do it right but there is always time to do it over