Using one Form to view different queries

[Marcus]

Wondering if it is possible to use one form to open different
queries at different times. As an example, I may have
frmViewQueries that opens up when I click a command button on
frmMain. So, the code for the command button might be

DoCmd.OpenForm "frmViewQueries", acFormDS

So, frmViewQueries actually provides a datasheet view of qryQuery1.

Now, what if later on I want to open qryQuery2 in the same
frmViewQueries form. Is this possible? Can I change the
RecordSource of frmViewQueries some how? Something like this

frmViewQueries.RecordSource = qryQuery2
DoCmd.OpenForm "frmViewQueries", acFormDS

How can I tell frmViewQueries what columns from qryQuery2 to display?
Marcus
******

[Trevor Best]

Marcus wrote:

Wondering if it is possible to use one form to open different
queries at different times. As an example, I may have
frmViewQueries that opens up when I click a command button on
frmMain. So, the code for the command button might be

DoCmd.OpenForm "frmViewQueries", acFormDS

So, frmViewQueries actually provides a datasheet view of qryQuery1.

Now, what if later on I want to open qryQuery2 in the same
frmViewQueries form. Is this possible? Can I change the
RecordSource of frmViewQueries some how? Something like this

frmViewQueries.RecordSource = qryQuery2
DoCmd.OpenForm "frmViewQueries", acFormDS

How can I tell frmViewQueries what columns from qryQuery2 to display?

The .Recordsource property can be used to change the data source on the
fly but can only be used after the form is opened.

DoCmd.OpenForm "myform",acNormal,"MyQuery"

will open it with a different query. If your queries have the same
column names then this is no problem but if they're different then
you'll be stuck with either having to predefine what queries you can
use, bind controls to the columns and show/hide at runtime or else set
the .controlsource property of the controls at runtime.
--
[Oo=w=oO]

[Fred Zuckerman]

"Marcus" <to*******@yahoo.ca> wrote in message
news:11**********************@g43g2000cwa.googlegr oups.com...

Wondering if it is possible to use one form to open different
queries at different times. As an example, I may have
frmViewQueries that opens up when I click a command button on
frmMain. So, the code for the command button might be

DoCmd.OpenForm "frmViewQueries", acFormDS

So, frmViewQueries actually provides a datasheet view of qryQuery1.

Now, what if later on I want to open qryQuery2 in the same
frmViewQueries form. Is this possible? Can I change the
RecordSource of frmViewQueries some how? Something like this

frmViewQueries.RecordSource = qryQuery2
DoCmd.OpenForm "frmViewQueries", acFormDS

How can I tell frmViewQueries what columns from qryQuery2 to display?
Marcus
******

If your different queries are all based upon the same table(s) and the only
differences between the queries are the "criteria", then you can open the
form with the recordset directly to the table and use the filter parameter
to select the desired criteria. Example:
DoCmd.OpenForm "frmViewQueries", acFormDS,,"Year(fldDate)=2004"
Fred Zuckerman

[Arno R]

Marcus,
In the recent (11-05-2005) thread 'Datasheet forms and columnwidths' you will find an answer from Stephen Lebans where he refers to an article by Michael Kaplan. Read this article until the end.
Quote: "Access 2000 takes this a step further to support using tables and queries directly in the Subform control as a SourceObject."
I just tried and it works great. Set columnwidth to -2 and all queries will adjust themselves.
You can also control the fontsize and visibility and so on.
I you need code I can help but read the article and 'play with it'.

Arno R

"Marcus" <to*******@yahoo.ca> schreef in bericht news:11**********************@g43g2000cwa.googlegr oups.com...

Wondering if it is possible to use one form to open different
queries at different times. As an example, I may have
frmViewQueries that opens up when I click a command button on
frmMain. So, the code for the command button might be

DoCmd.OpenForm "frmViewQueries", acFormDS

So, frmViewQueries actually provides a datasheet view of qryQuery1.

Now, what if later on I want to open qryQuery2 in the same
frmViewQueries form. Is this possible? Can I change the
RecordSource of frmViewQueries some how? Something like this

frmViewQueries.RecordSource = qryQuery2
DoCmd.OpenForm "frmViewQueries", acFormDS

How can I tell frmViewQueries what columns from qryQuery2 to display?


Marcus
******