I have several combo boxes in a custom ribbon.
How can I set a value to one of them with VBA?
Thanks.
Edit: I can select a name from combo box. The table/form/reports opens. I need to set the combo back to blank. In above screen shot, I want to change tblEmaergencies to blank/null.
How can I set a value to one of them with VBA?
XML:
<group id="grp_objects" getLabel="getLabel">
<comboBox id="cmb_tbls" getLabel="getLabel" getItemCount="getItemCount" getItemLabel="getItemLabel" onChange="OnChangeComboBox" sizeString="MMMMMMMMMMMM">
</comboBox>
<comboBox id="cmb_frms" getLabel="getLabel" getItemCount="getItemCount" getItemLabel="getItemLabel" onChange="OnChangeComboBox" sizeString="MMMMMMMMMMMM">
</comboBox>
<comboBox id="cmb_rpts" getLabel="getLabel" getItemCount="getItemCount" getItemLabel="getItemLabel" onChange="OnChangeComboBox" sizeString="MMMMMMMMMMMM">
</comboBox>
</group>
Thanks.
Edit: I can select a name from combo box. The table/form/reports opens. I need to set the combo back to blank. In above screen shot, I want to change tblEmaergencies to blank/null.
Last edited: