Store values from a multi-selection list box

[sguan]

Hi all,

I am a newbie in Access, and I have made a list box on a form that can have multiple selection.

Is there a code I can put in the On Click event in the property settings that can help me to store the multiple selected values in one single field in a table where the values are spearated by a comma?


Thanks & regards,

Suzanne

 

[John Big Booty]

This link describes how to use a multiselect list box to filter a Report. You should be able to use the same principal to store those values selected in the list box.

 

[sguan]

Thanks John,

This is really helpful.

A second question to this topic;

How can I auto-clear the selected values in the listbox for a new record?

Thanks!

 

[John Big Booty]

This link should set you on the right track.

 

[RenaG]

Hi John,

This is exactly what I am looking for! I followed the link (making the necessary changes for my situation). When I ran it, I got an Error 3071:

This expression is typed incorrectly, or it is too complex to be evaluated. For example, a numeric expression may contain too many complicated elements. Try simplifying the expression by assigning parts of the expression to variables.

I am new to Access and don't know how to debug the code. How can I find out what command is wrong and what is in it?

TIA!
~RLG