I created an Access DB with a field that has multiple value lookup. I want to create a button that allows the user to SetProperty in VB for certain fields. It works fine for all fields but doesn't work on selecting values from the multivalve field. Is there a way to do that programmatically?
For example, the field has 5 values which allows multiple entries (A,B,C,D,E). I want the button to select choices "A,C" programmatically. Is that possible using the Set Property or any other Visual Basic way?