Results 1 to 3 of 3
  1. #1
    5 Star Lounger
    Join Date
    Nov 2001
    Location
    Jerusalem, Israel
    Posts
    708
    Thanks
    0
    Thanked 1 Time in 1 Post

    Adding multiple record using 2 list boxes (xp)

    I know I have seen a demo for this somewhere but cannot find it.
    I would like to create a form with 2 list boxes -
    1) All students in the school
    2) Empty

    At the top pf the form is which class we are registering, and as I click on either one or multi select and D&D, they move to the empty box, leave the full one and are registered in the class through recordset code behind the form.
    If anyone has any ideas- thanks. If not I will roll up my sleeves and get to work.

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

    Re: Adding multiple record using 2 list boxes (xp)

    See MSKB article How to simulate drag-and-drop capabilities in Access 2002. A working demo is available in the Access 2000 Sample: Database of Sample Forms.

    Instead of simulating drag-and-drop, you can also use command buttons to move items back and forth between list boxes.

  3. #3
    3 Star Lounger
    Join Date
    Jun 2002
    Location
    Nottingham, Nottinghamshire, United Kingdom
    Posts
    257
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Adding multiple record using 2 list boxes (xp)

    Helen Feddema covered using multiple select list boxes some time ago in her Access Archon column for Woodys Access Watch. I found her code perfect for my purpose. Try her website.

    David

Posting Permissions

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