Hi Mike,

I have a similar problem, but I need to go a little further. I understood how to feed the column ultradropdown datasource depending of another cell value, but how can I manage this situation correctly and easily:

Let's say I populate a cell's combobox of row 1 from another cell in row 1. Now I add a second row (row 2). Then I populate the cell's combobox's of row 2 depending of a value in row 2. If I go back to row 1 and I open the combobox's cell, it will be populated with combobox's row 2 list.

So how can each cell's combobox can keep their own list?

Thanks,

Olivier

Hi Olivier,

Did you look at the article I posted above? This article explains how to handle this and it works just fine no matter what row you move to.

Thanks for your quick answer.

If I understood correctly the other article, we need to initially load a whole list and to filter it within the BeforeCellActivate event depending of cell value, but what if I don't want to load a whole list initially because there are too much items in it?

If it is the only way to do it I will try it but performance-wise, it is really not my best option.

Thanks again.

Well, if you don't want to load all of the data up front, then you can assign a ValueList to each cell individually. It sounds to me like you are changing the ValueList on the Column instead of the cell, and so it's applying to all cells in the column.