List box

[Stephanie]

Hi. Is it possible to have a multi-select list box?
I'm trying to set up a form where the user can select 1 or more reasons for
an issue, and a score would automatically be assigned to each of the reasons.
Based on the sum of the scores, a field would turn red, yellow or green.

Could you suggest how this could be achieved?

Thanks,
Stephanie

 

[PieterLinden via AccessMonster.com]

Hi. Is it possible to have a multi-select list box?
I'm trying to set up a form where the user can select 1 or more reasons for
an issue, and a score would automatically be assigned to each of the reasons.
Based on the sum of the scores, a field would turn red, yellow or green.

Could you suggest how this could be achieved?

Thanks,
Stephanie

You would have to write code to process the ItemsSelected collection of the
listbox and then write that to a table, with which you could use DSUM to
calculate the score.

 

[Linq Adams via AccessMonster.com]

You would also have to set the Listbox Multi-Select Property to either Simple
or Extended; the Default, I believe, is Non or None.

 

[Stephanie]

Thanks for the tip.

 

[Stephanie]

Thanks for the information. I've seen a few other posts on the subject so
I'll review those as well.