Multiple select list box

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi,

I have created an application that keeps track of people who have been to
classes. I want to create a section called Build a Roster. We have about
500 people who are registered for class. I want them to all appear in a
collumn on the left with a scroll bar. I then want both an Add and a remove
button in the center. on the right I want a box to add people to a specific
class. Whenever they are added I click a Done button and they are sent to a
table. Also, is it possible to make this a subform. Can someone help me
with this?

Thanks,
 
I'm thinking you want a form like this:
-----------------------------------------------------------------------
Class No: XXXXXX (Combo box)

Person:(List Box) Class Members(List box)
John Smith Add>> Linda Carter
Steve Austin <<Remove
Linda Carter

-----------------------------------------------------------------------

Where Add>> and <<Remove are buttons, let's start with this assumptions:
1.Your person's table has an Id (like a number or code), your class has its
own Id as well (Class_No)
2.You need a table that will connect the 2 together:
Class_Student_tab(Class_No,Person_Id)
3.The first list box in your form is bound to the person table, and the
second is bound to Class_Student_tab linked to the class_no shown in the form
4.The Class_No field can be a combo box to select classes

Here is the trick
-Button Add>> will simply execute a query that appends a record to the table
Class_Student_tab with the selected person in the person list and the
class_no from the form
-Button <<Remove will delete a record from the table class_student_tab where
the person id is selected from the second list and the class_no in the form
-Both buttons will have to refresh the second list box after execution
 
Back
Top