List box trick

  • Thread starter Thread starter Peter Marshall at OCC
  • Start date Start date
P

Peter Marshall at OCC

I have seen this somewhere so I know that it's possible. I have a Training
Classes database with a Classes table, an Employees table, and a union table
(many-to-many) of class attendees. On the form where I specify employees
that have attended a particular training class, I would like to have a combo
or list box of all possible employees and be able to click and control-click
multiple attendees for that class. For each employee that I have clicked
on, I would end up with a record for that employee in that class in my union
table. Can one of you experts help with this?
 
Peter,

Use a multiselect lstbox for selecting attendees. Then after selecting
attendees, have a button on the form that cycles through the itemsselected
collection of the listbox and appends the selected attendees to your union
table. Append using an append query or better append SQL.
 
Back
Top