Multivalue Field

Copper Contributor

Hello

 

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?

 

Thanks!!

1 Reply
you can try to use VBA to add code to the Click Event of the button:

private sub Btn1_Click()
Me!TextboxName = Array("A", "C")
end sub