Use a ListBox for a Report

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
 
A

Allen Browne

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]
 

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

Top