Results 1 to 5 of 5
  1. #1
    2 Star Lounger
    Join Date
    Apr 2008
    Posts
    188
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Multi Selections in a Listbox (2002)

    I have created a listbox that lists weeks of the year. I want to select one and then have the value be used as criteria in a query.

    I know how to do this with a combobox but for some reason I can't get it to work with a listbox. What am I not doing?

    Thanks.

    Paul

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Multi Selections in a Listbox (2002)

    How are you using the list box, and where exactly does it fail?

  3. #3
    2 Star Lounger
    Join Date
    Apr 2008
    Posts
    188
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Multi Selections in a Listbox (2002)

    I have the list box on a form. You highlight the date from the listbox. I have the query looking in that listbox for the criteria it needs to run. I then push a button on the form and the report is supposed to open. Nothing happens.

    I did this with a combo box and it works. I want to use a listbox because you are supposed to be able to select two dates and then use both for the query. I don't think you can do that with a combo box.

    I think I'm missing some step in the process.

    Paul

  4. #4
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Multi Selections in a Listbox (2002)

    See <post:=465,456>post 465,456</post:> for an example of the kind of code you can use for a multi-select list box.

  5. #5
    2 Star Lounger
    Join Date
    Apr 2008
    Posts
    188
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Multi Selections in a Listbox (2002)

    That worked.

    Thanks again.

    Paul

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •