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

Filtering records for Report that depend on dropdown

P: 68
Hi,
I have a table with list of schools with teachers, gender, county, district etc. I would like to generate a report of each school with the details of teachers etc. from the selection of a school from a combo box dropdown list.
Can anyone help with this?
Thanks,
Oscar
Aug 15 '12 #1
Share this Question
Share on Google+
4 Replies


twinnyfo
Expert Mod 2.5K+
P: 3,284
Stoic,

When you create your report, use a query that uses the value in that Combo Box as the crteria for the School field. Then, whenever you select a school, only the info for that school will show up on the report.

Hope this helps.
Aug 15 '12 #2

zmbd
Expert Mod 5K+
P: 5,397
Have a look at the following tutorial
http://bytes.com/topic/access/insigh...filtering-form

You'll also want to follow the links given at the bottom of the tutorial as they expand in the basic article.

-z
Aug 15 '12 #3

P: 68
Hi twinnyfo,
Thanks for the add; I think you are grasping the idea I am wishing to have. Example: I have a table with names of schools, county, teachers etc.
Now, I want to have a form example "report form" with a combo box with the list of schools and a button that populates, when click, the information of the school with the list of teachers in my report I have formatted as "List of teachers by School".
Can you help me with that?
Thanks.
Aug 15 '12 #4

twinnyfo
Expert Mod 2.5K+
P: 3,284
Stoic,

When you build your query, in the criteria section of the query builder, right click, then select "Build..." and you should be able to set as your criteria one of the text boxes on your form. This way, the query will only select the records that meet that criteria. Then, use this query as the record source for your report.

Could you show us what you have so far? It's impossible for us to "build" that for you without your database, and most of us have jobs, too! ;-)

If you show us what your are working on and then describe in detail what "doesn't work" we can move forward from there.

Thanks...
Aug 15 '12 #5

Post your reply

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