Use a ListBox for a Report

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Cissy - 05 Dec 2005 03:04 GMT

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

Reply to this Message

Allen Browne - 05 Dec 2005 03:21 GMT

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]

Signature

Allen Browne - Microsoft MVP. Perth, Western Australia.
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

> Hi, I've used combo and list boxes on forms lots of times, but now I'm
> trying
[quoted text clipped - 7 lines]
> appreciated.
> Thanks

Reply to this Message