ms access 2007 - Combo Box with multiple selections clicking ok -

in access multi combo box have requires me click okay add selections box. there vb code make when check beside selections automatically adds them box when leave it?

if using sharepoint database, add sharepoint tag post.

if not using sharepoint, research indicates should not use multi-valued combo box.

• reference 1
• reference 2
• reference 3
• reference 4

it's 1 of features provided access tries offer shortcut while undercutting database design. original classic lookup field.

if still want use feature, vba might let smooth user experience using docmd.setwarnings.false , (later) docmd.setwarnings.true.