Save combobox value when display/fields property is set from two columns

[tonykiefer]

I have a combo box populated with items from two sql columns.  The display/field property is set like so...

["PRM_ML","PRM_CD"]

The ComboBox...

The two combined fields need to be save as one value in the record set but I'm not sure how to write the Update property.

I tried multiple combinations of syntax with no luck.

MainFabric_ComboBox.SelectedItems.PRM_ML,PRM_CD

Please help

[gabibalaban · Accepted solution]

@tonykiefer ,

MainFabric_ComboBox.Selected.PRM_ML & MainFabric_ComboBox.Selected.PRM_CD

 It is unclear if your combobox support multiple selection (in this case the above formula will not work)

Hope it helps !

[tonykiefer]

@gabibalaban...Thank you for the feedback.  I did not try that syntax.  I also forgot to mention the combobox is NOT set for multiple selections.  This solution works.  Thanks again!

[JR-BejeweledOne]

You can do this with a multi-select combobox:  Replace 'yourcomboboxvaluehere' and 'YourComboBoxValue' with the value property of your combobox. 

Concat(MainFabric_ComboBox.SelectedItems.yourcomboboxvaluehere, YourComboBoxValue & ", ")