Creating a report from a query using drop down box parameters

C

Colin Reed

Hi all

I'm wanting to create a report from a database of schools, colleges and youthgroups. These are selected as one of seven types from a drop down list, eg primary school, youth group, etc. If I want to print out a report of just the primary schools I will do this via a query. How do I get the user to select from the same drop down box in the query, rather than typing in "primary school" etc? I'm sure I once knew how to do this, but am using Access for the first time in about 6 years, and have forgotten lots!!

Thanks all

Colin

EggHeadCafe - Software Developer Portal of Choice
Updated: Production Exception Handling For Dummies 101
http://www.eggheadcafe.com/tutorial...5c-a3f5b2184aa5/updated-production-excep.aspx
 
R

Roger Carlson

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Delete every word with all or partial underline 5
importing data from another table 3
Report list in a drop-down box 7
using a from to query a report 2
report and drop down list? 4
report using a subreport based on a crosstab query 5
Parameters and Drop Down/Combo Box 1
Word 2003 using data from a drop down list (legacy form field) 0

Top