Filtering records for Report that depend on dropdown

[Stoic]

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

[twinnyfo]

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.

[zmbd]

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

[Stoic]

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.

[twinnyfo]

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...