Results 1 to 3 of 3
  1. #1
    3 Star Lounger
    Join Date
    Apr 2001
    Location
    Joliette, Quebec, Canada
    Posts
    290
    Thanks
    9
    Thanked 0 Times in 0 Posts

    multi-selection list box on a form for a report (2002)

    I would very much like to use a multiple select feature on a list box on a form in order to generate a report. The report is based on a cross tab query. I would like to know if is possible to set the list box with more than one column (like 3 columns and 20 rows). I would like to see a demo if someone could point me the right direction.

    Richard <img src=/S/dizzy.gif border=0 alt=dizzy width=15 height=15>

  2. #2
    4 Star Lounger
    Join Date
    Aug 2002
    Location
    Dallas, Texas, USA
    Posts
    594
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: multi-selection list box on a form for a report (2002)

    The column count shouldn't matter, as long as the 'criteria' you are using from the listbox is the bound column.

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

    Re: multi-selection list box on a form for a report (2002)

    1. A multi-column listbox is easy: use a table or query with (at least) the columns you want to display as the Row Source of the list box (Row Source Type is Table/Query). Set the Column Count properrty to the number of columns you want to display. Set the Column Widths property to a semi-colon list of column widths, for example 2 in;3 in;1 in.

    2. To enable multiple selections, set the MultiSelect property of the list box to Single or Extended. Single means that you can select and deselect items by clicking on them. Extended means that you select items the way you do in Windows Explorer: use Click to select a single item, Shift+Click to select a contiguous range of items, and Ctrl+Click to select/deselect individual items. If you search this forum for multi select, you'll find lots of posts on this subject. <post#=205119>post 205119</post#> contains a method for using the selected items in the WHERE-condition of an SQL statement. That technique can easily be adapted for use in opening a report.

Posting Permissions

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