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]
 
Back
Top