multi-select combo box

[sjolley]

i have a form, linked to a qry.

i have the below multi-select combo box where i show the description as one column, and a value as one column. the combo box values come from a separate table.

When making a selecting, the description is returned and stored into the table. Which is what i want.

What i also want, is the value to be also stored into a different field in the table. so depending on the description and the amount of descriptions selected, the numeric value will change.

How can i best sum up the numeric value of the selected values, eithin within the qry or by using vba code within the form to store to a seperate field.

any ideas would be greatly appreciated.

[CJ_London]

Why? You just look it up when required

also please clarify your terminology- multi select refers to a listbox. Perhaps you mean a multi value combo box? They are not the same and the latter comes with many limitations.

[ano]

after update vba code to do what u have in mind

[June7]

First, don't recommend using multi-value field at all.

Second, save the ID not the description.

Third, build query to retrieve related data.

[Welshgasman]

Good luck getting a response from the O/P.
This is their other post. https://www.accessforums.net/showthr...160#post378160