Multivalued combo box

[ezz]

Hi,

I've been struggling with this for a long time now.

I have a field in a table that I want it to be multivalued. The values are stored in a different table. I tried to do that and it worked fine. But when I wanted to display a pie chart in a report based on a query, the values didn't show up.



Example:

EmployeeName: X
TermenationReasons: 1,2,3 (multivalued field - values stored in a different table)


I though of just changing the field type to a text, and create a combo box in the form that allows me to add multiple values, and appear on the table and the query, and the pie chart too.

I don't know how to make a multivalued combo box in a form. Am I doing something wrong? Is there an easier way to do that?

[ranman256]

Yes, the easiest way is NOT to do multi select box.
instead, 2 lists, 1 is the list of items available.
2 is the list of the picked items.
when the user dbl-clicks list 1, execute an append qry to the picked table. Then refresh the 2nd list.

lst1_dblClick()
docmd.hourglass ffalse 
docmd.openquery "qaAddPickedItem"
lst2.requery

[ezz]

Yes, the easiest way is NOT to do multi select box.
instead, 2 lists, 1 is the list of items available.
2 is the list of the picked items.
when the user dbl-clicks list 1, execute an append qry to the picked table. Then refresh the 2nd list.

lst1_dblClick()
docmd.hourglass ffalse 
docmd.openquery "qaAddPickedItem"
lst2.requery

Thank you, ranman256. I'll give it a try.

But will I be able to create a pie chart in a report that displays the percentage of how many times a certain value was chosen?

[ranman256]

You can make the chart from the PICKED list, tho Im not sure exactly what you need.