Test whether a multivalue combobox still contains a particular value
Posted on 2012-08-22
I have a Access 2010 form with a multivalued combo box on it. (Please, no lectures about this being a bad idea -- take it as read that I understand the pros and cons).
When the user updates this combo, I need to test whether they've removed a particular value from it and check with them whether they really meant to do so or if it was a mistake.
My preferred approach would be to code the beforeupdate event for the combobox, so need to be able to access the values in the form (rather than the underlying multivalued field in the data table). How can I code this in VBA?
[I guess my fallback will be to code the afterupdate event, access the underlying multivalued field (which I know how to do) and re-add the required value if the user made a mistake.]