UPDATE: I have answered my own question; See below if interested.
***
Original question:
I am having trouble setting up a combobox to do all of the following:
* The combobox is bound to a column in a table.
* The current record is selected/displayed in the combobox (vs. an empty display where you have to select to display a value).
* The combobox list does not contain repeating values from its bound column, e.g. if the bound column contains the values Region 1, Region 2, and Region 3 those values need to be displayed only once in the combobox, not for every occurrence of those values in the source table.
This seems like an easy problem, but playing with the control and searching help I have not been able to find a solution.
Thanks in advance.
***
Original question:
I am having trouble setting up a combobox to do all of the following:
* The combobox is bound to a column in a table.
* The current record is selected/displayed in the combobox (vs. an empty display where you have to select to display a value).
* The combobox list does not contain repeating values from its bound column, e.g. if the bound column contains the values Region 1, Region 2, and Region 3 those values need to be displayed only once in the combobox, not for every occurrence of those values in the source table.
This seems like an easy problem, but playing with the control and searching help I have not been able to find a solution.
Thanks in advance.
Last edited: