Results 1 to 4 of 4
  1. #1
    4 Star Lounger
    Join Date
    May 2003
    Location
    Manchester, Gtr Manchester, England
    Posts
    552
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Combo to List (2000)

    Hi, I'm not sure if this is achievable, none the less - Have a combo (unbound), each time I click from the combo I want the selection to appear in a list box. In turn this list box creates new entries in an underlying table. Example:
    Ford is selected from combo it then shows in the list box, next Vauxhall is selected from the combo and shows in the list under ford, in turn Ford and Vauxhall become entries in two seperate rows in the appropriate table. Each time a record is added on the form the list box then sets back to empty ready for the next entries.

    Many thanks Darren.

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

    Re: Combo to List (2000)

    If I understand your intention correctly, it would be better to create a continuous subform with a combo box. But I'm far from sure about this; your description doesn't make it clear what belongs where.

  3. #3
    4 Star Lounger
    Join Date
    May 2003
    Location
    Manchester, Gtr Manchester, England
    Posts
    552
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Combo to List (2000)

    That's fine Hans, I'll go that way.

    Cheers Darren

  4. #4
    Gold Lounger
    Join Date
    Jun 2001
    Location
    Crystal Beach, FL, Florida, USA
    Posts
    3,436
    Thanks
    1
    Thanked 34 Times in 34 Posts

    Re: Combo to List (2000)

    Of course, the first question that needs to be asked is why bother using the listbox at all; why not just write the records directly when selected from the combo box?

    But anyway, assuming there are a finite number of selections being made, just make your listbox a Value List. In the AfterUpdate event of your combo box, just add this code:
    myListbox.RowSource = myLIstBox.rowsource & myComboBox & ";"

    Later, after you add the records to the table, merely do:
    myListBox.RowSource = " "
    Mark Liquorman
    See my website for Tips & Downloads and for my Liquorman Utilities.

Posting Permissions

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