By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
435,241 Members | 775 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 435,241 IT Pros & Developers. It's quick & easy.

Saving and applying a query on a form/subform

P: 6
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
Dec 19 '07 #1
Share this Question
Share on Google+
1 Reply


Expert 100+
P: 374
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.
Jan 5 '08 #2

Post your reply

Sign in to post your reply or Sign up for a free account.