Adding multiple record using 2 list boxes (xp)

Topic

New Reply

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.

Reply | Quote

Replies

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.

Reply | Quote

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

Reply | Quote