Results 1 to 3 of 3
  1. #1
    2 Star Lounger
    Join Date
    Jan 2001
    Location
    Pennsylvania, USA
    Posts
    144
    Thanks
    0
    Thanked 0 Times in 0 Posts

    MultiSelect ListBox (97,2000,2002)

    I have a form that I've named "fdlgSupplierDrillDownDialog". On this form there is a ComboBox named "cboSupplier", from this comboBox you can select (All) being all suppliers or a single Supplier. Also on this form is a Listbox named "lstInventoryItem", when (All) is selected in the cboSupplier all of the inventory Items are listed in the ListBox, if a single Supplier is selected only those items from that supplier are listed. Last on the form are two textboxes "txtFromDate" and "txtToDate", these are self explanatory.

    This Form is used to select the parameters for a report. I would like the ListBox to be MultiSelect but can not get it work all else working fine. MultiSelect property is set to Simple
    In the query for criteria I have Like Forms!fdlgSupplierDrillDownDialog!lstInventoryItem

    Is this the correct way to do this, am I missing something.
    threecrow

    Don't make excuses. It's what you do, not why you didn't.

  2. #2
    Gold Lounger
    Join Date
    Feb 2001
    Location
    Sint Niklaas, Belgium
    Posts
    2,778
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: MultiSelect ListBox (97,2000,2002)

    Have a look at these kb article :
    How to Use a Multi-Select List Box to Filter a Form
    Francois

  3. #3
    2 Star Lounger
    Join Date
    Jan 2001
    Location
    Pennsylvania, USA
    Posts
    144
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: MultiSelect ListBox (97,2000,2002)

    No sir I haven't, will take a look

    Thank you kindly
    threecrow

    Don't make excuses. It's what you do, not why you didn't.

Posting Permissions

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