Use a ListBox for a Report

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi, I've used combo and list boxes on forms lots of times, but now I'm trying
to run a report I have tied to a query that prompts for a category. As it is
now, the user has to have a printed list of categories to choose from. I
want them to select from a listbox when they run their report so that the
choice from the listbox answers the promt the query is looking for (in my
query, I have [Enter Category] in the criteria row). I'm using Access 03.
Any help or direction on where I can find out how to do this is appreciated.
Thanks
 
If the list box is named List1, and it lives on Form1, then open your query
in design view, and replace:
[Enter Category]
with:
[Forms].[Form1].[List1]
 
You must log in or register to reply here.

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

PROBLEM - Report based on query that has criteria based on listbox 3
Access Cannot select items in listbox 1
Dynamic report using listbox 2
choosing multiple parameters for a report 7
Dsiplay selections from a listbox on a report 2
Using select and crosstab queries on one report 1
VBA: How can I use a string variable as autofilter criteria? 4
size a listbox dynamically 2

Back
Top