ComboBox linked to data view only showing first value

I am trying to display a certain column within a dataview as the options within a ComboBox. The dataview is being populated correctly, and the ComboBox displays properly if the dataview only contains one row. However, if the dataview contains multiple rows, the ComboBox only displays the value in the first row as the option. I assume that’s because it is the selected row.

Is there anything I have to do to tell a combo box to display all rows of a dataview, not just the selected one? I’ve checked the dataview in the Ctrl+Shift+B menu, and its displaying all the rows I would expect.

Below are some screenshots of the Combobox settings.

Phases = Source Dataview
ProjPhase_PhaseID = Column in Source Dataview I want to display as options




image

You might try to start with the minimum to get it working:

In this case, the minimum for a data view combo is the View Name, TextField, and Value Field…
If that pulls what you expect, then add in your sort and that should be enough for a basic combo

I’m just thinking that there is a lot of extra stuff that you shouldn’t need - and it might be confusing things

Ah, that did it, thank you!

I needed to fill in EpBinding as well or the dropdown was greyed out, but otherwise those three got me what I wanted.

Thank you, appreciate the help!

1 Like

This was a great suggestion, it worked for me also.
My problem now is that the combo is not populating when loading, but as soon as I click on it, it’s showing the correct data.
Below are the combo box setup and results screenshots:

image

Try adding CodeDesc to your Retrieve Columns property. See if that will get it to display when it is first loaded.

Thanks David,
Populating the Retrieve Column with UserCodes_CodeDesc did not have any effect at all.

It helps not to give up, I finally was able to make the combo boxes to populate correctly.

1 Like