Multiple Entries from Populated Combo Box to a Subform

  • Thread starter Thread starter tking
  • Start date Start date
T

tking

Good morning..an example of what I need done would be easier to explain. I
have a table populated with a list of training courses and their related
information, course code, name etc. I need the user to select the courses
required and then have those courses appear, either on the form itself or in
a subform. Additionally, the user would then select, from the same list,
(different combo box) those courses the person in question has completed,
which also must appear on the subform. Once selected and present on the
subform, I need a query to filter the courses completed from the courses
required, and then show the resultant list of courses still required.
 
Based on your description, I think you need to look into using one or two
multi select list boxes. Since you can select only one item from a combo
box, I don't think that would work for you.

A multi select list box has an ItemsSelected collection that contains each
row the user has selected. This can be very helpful in this situation.
 
Back
Top