assigning multivalued combobox null array

I

icccapital

I have been successful in using multivalued combobox and assigning array of
values to the .value of the combobox to change the selections. The only
place I have an issue is if I want to deselect all options. When looking at
the vba code during runtime I can see that if there is no selection in the
combobox, then .value will return NULL, but it doesn't like when I try to
reassign it a null array variant and returns "Cannot perform this operation"

Any thoughts?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

deselect all multivalued combobox 2
access multivalued field combobox from vba 3
Need combo box to refresh when moving to new record 2017 1
Replacing "null" with "(default") in a combobox 4
combobox null entry 3
Error: You tried to assign a null value... 2
Looping with Multiple Controls 1
Combobox Afterupdate Event setting text box value 2

Top