Saving and applying a query on a form/subform

[jcf378]

Is it possible to set a main-form with an embedded subform to "Filter by Form", subsequently enter the desired variables in fields in BOTH the main-form and subform, and then save the resulting filter as a single query? or, do the variables entered on the main form need to be saved as its own individual query, and the variables entered on the subform saved as a separate query.

I ask because I would ideally like to take a single query, containing filter variables that apply to both the mainform and subform, and be able to load/apply it onto a blank mainform/subform.

So in short, is it possible to save, and then apply, a single query that contains filter variables from both a mainform and its subform?

thanks,
-Jason

[PianoMan64]

Jason,

Is there a relationship between the Main and subform that you're speaking about?

Normally what I do when I'm wanting to filter the form based on a set of values, I normally have a list control that lists out all the items of the main table, then when I double click on a list item, then I zoom into the detail of that records children, and then have a button that will zoom out so that it can show the main table list again.

I have a relationship between the two tables linked by a common ID field.

Is this what you're wanting to do?

Let me know.

Joe P.