multivalued combo box, test if field is checked/selected

[matben]

Hi,

i need to create macro, on insert. which will send mail if is selscted specificed value in combo multivalued list.
but, i cant access to that field to test it.

i have tried:

([USERS].[TYPE].[Value])1 = "admin"


([USERS].[TYPE].[Value])1 = 1
[USERS].[TYPE].Value(1) = "admin"
[USERS].[TYPE].[Value]1
[USERS].[TYPE].Column(1) = 1
[USERS].[TYPE].selected(1)
[USERS].[TYPE].[admin]= true
..........
..........
..
-i have tried bound Column = 0, 1....
- tried with selected atribute..


and many variations on that theme, but i cant get to that value to test it?
can someone give me some advice?

thanks in advanced,
Marko

[June7]

I NEVER use multi-value fields. Why are you?

I don't think can even 'capture' the value of item selected in multi-value combobox.

[matben]

I have an inherited access database. and i need to modify that. only becouse of that.