Results 1 to 2 of 2
  1. #1
    Join Date
    Aug 2003

    Unanswered: Multi select list box


    I have a multi select list box in my form, when I select the items from list I want to be able to store them in a separate table, which I can use later for querying.

    This seems to involve visual basic coding. I am not well versed with it. I am not sure where t start looking for a solution.

    Could anyone help me out with this?


  2. #2
    Join Date
    Jul 2003
    First give your list box a cool name, like MYLISTBOX.
    Then you'll find in VBA a element in your form called mylistbox.
    And this element has methods and properties.

    Example (where me points to your form):
    for i=0 to me.mylistbox.listcount-1
    if me.mylistbox.itemdata(i).selected then ...
    next i

    hope this was not too short...

Posting Permissions

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