How to run queries on a subset of records in a table?

[Roger Green]

I have inherited a complex database that has many dozens of queries that derive data from a people
table.

I now need to be able to run these queries (from within a significant number of forms) not on the
full dataset, but on a subset of the data in the people table.

I want to avoid having to put criteria in all of the individual queries or forms, or having to
change the data source for all the queries.

Is there anyway I can restrict the recordset without having to modify all the queries individually?

[Dennys G.]

Consider a query by form (QBF). The QBF is a form in which you can enter
multiple variable parameters that are sent to your queries when the queries
are activated. The QBF is an unbound form with unbound text boxes on it
that are used to supply parameters to the queries. Multiple queries can be
fed off this form. The queries refer to the unbound controls/text boxes on
the QBF by there names so that when you fill the text boxes and activate the
queries, then the queries are filtered by whatever was placed in the text
box(es). In the criteria rows of your queries, you would place expressions
similar to this: [Forms]![frmNameOfUnboundForm]![txtNameOfUnboundTextBox]

Denny G


"Roger Green" <rc*****@mun.caNOJUNK> wrote in message
news:bj**********@coranto.ucs.mun.ca...

I have inherited a complex database that has many dozens of queries that derive data from a people table.

I now need to be able to run these queries (from within a significant number of forms) not on the full dataset, but on a subset of the data in the people table.

I want to avoid having to put criteria in all of the individual queries or forms, or having to change the data source for all the queries.

Is there anyway I can restrict the recordset without having to modify all the queries individually?