Multi Value Selection without using lookup wizard

[caniread]

I have a database that people submit ideas to. A list box lets them choose their name from another table with all the employees names. The idea might come from more than one person so I want to be able to pick more than one person. I can see how you do it using the look up wizard but I want to avoid it as that causes problems. How do I go about making that possible without using the look up wizard?

[ranman256]

multi-select list boxes require a lot of vb code.
OR
you can use a single select list box that adds the user picks to a 'picked' table (append query on the dbl-click)
then once all the picks are made , then in a select query, the tPicked table is joined to the data table to produce the results .
No code, 2 queries.

[caniread]

Sounds good but I am unsure how to accomplish what you have described. If you have time could you provide a more detailed set of instructions. Thank you,

multi-select list boxes require a lot of vb code.
OR
you can use a single select list box that adds the user picks to a 'picked' table (append query on the dbl-click)
then once all the picks are made , then in a select query, the tPicked table is joined to the data table to produce the results .
No code, 2 queries.

[orange]

caniread,

Can you tell us in 4 -5 lines what the "business" is in plain English?
Also can you show readers your table design(s)?

I see Employee and Idea. You probably have some Category, Class or Type of Idea, and perhaps some descriptive text (or some standard terms of which 1 or more can be associated with an Idea).

It is important to get your tables and relationships designed to meet your business needs before getting too far into forms etc.

One or more Employee(s) can submit 1 or more Ideas

[Missinglinq]

Storing multiple pieces of like data, in a single field, is generally frowned upon, but for something like this is probably OK. In the below, replace YourComboBox and TargetTextBox with the actual names of your Controls:

Private Sub YourComboBox_AfterUpdate()
 If IsNull(Me.TargetTextBox) Then
   Me.TargetTextBox = Me.YourComboBox
 Else
   Me.TargetTextBox = Me.TargetTextBox & ", " & Me.YourComboBox
  End If
 End Sub

Linq ;0)>