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

Access Form to show sub form details based on query and updated query results

P: 1
I have two forms a main and sub. On the main form, I want to select a given set of criteria (i.e., "Project"), which pulls from a query and udpates a report number at the same time. I want to display the results of the project selected in a subform, based on a query I designed for the Projects. I want to be able to select check boxes (Yes/No) in the subform query data based on project details, and then have that data post to a table for reporting purposes. How do I go about doing this? I have struggled for hours.

Thanks
Feb 14 '07 #1
Share this Question
Share on Google+
2 Replies


maxamis4
Expert 100+
P: 295
which pulls from a query and udpates a report number at the same time.
Could you explain this piece a bit more?

I want to display the results of the project selected in a subform, based on a query I designed for the Projects. I want to be able to select check boxes (Yes/No) in the subform query data based on project details, and then have that data post to a table for reporting purposes. How do I go about doing this? I have struggled for hours.
Why use a query and not just the table that relates to projects. You must obvioulsy have a table labeled projects and another table which holds the detials of the project correct? If not could you provide the structure of the tables that make up this query?




Thanks
Feb 14 '07 #2

MMcCarthy
Expert Mod 10K+
P: 14,534
I have two forms a main and sub. On the main form, I want to select a given set of criteria (i.e., "Project"), which pulls from a query and udpates a report number at the same time. I want to display the results of the project selected in a subform, based on a query I designed for the Projects. I want to be able to select check boxes (Yes/No) in the subform query data based on project details, and then have that data post to a table for reporting purposes. How do I go about doing this? I have struggled for hours.

Thanks
Does this tutorial help you?

Example Filtering on a Form

Mary
Feb 15 '07 #3

Post your reply

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