multiple choices from multiple combo box

[capri]

Hi,

I have a table with a number of activities. I have another table that lists employees.
I have created a form with a combo box so that the person doing the input can assign an activity to an employee. That part works fine. However occasionally more than one employee will be responsible for the same activity. Usually not more than 3 employees to one activity. I even setup an employee called "not assigned" so I would have that option.

If I try and add 2 more similar combo boxes, so that the person doing the input can indicate if more than one person is assigned to the activity, it doesn't work. If I select John Doe in the first combo box, then John Doe is automatically selected in each of the other 2, which is not what I want.

Can anyone tell me what I am doing wrong or how I should approach solving this problem?

Thanks.

 

[D-Fresh]

Capri,

There are two solutions here... First if you wanted to use your approach, you need three combo boxes bound to three different fields. I would assume you have all three combo boxes assigned to the same field in your underlying table/query. Create three fields, Employee1, Employee2, Employee3 or something along those lines and bind each each combo box to each employee field.

The other approach is to use an unbound multi-select list box. Then when you save the record, you can then append the names selected into your Employee Assigned field, possible seperated by a semicolon for easy seperation later.

Like I said, either way will work, the former would be easier to set up. Hope this helps.

Doug