Forum Discussion

Ammar2400's avatar
Ammar2400
Copper Contributor
Sep 17, 2022

Multivalue Field

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!!

access
  • arnel_gp's avatar
    arnel_gp
    Steel Contributor
    Sep 18, 2022
    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

Share

Resources