Computed combobox not working. Works in ver 7

HCL Domino Domino Forum
1

Hi, I’ll try to make this simple. This does work in version 7.0 and I’ve tried it in my version of 8.5 and can’t get it to work.

I have a hidden field on a subform (called TheProductsFull) that does a database lookup and pulls in the necessary products. On the subform I have a combobox that uses the following formula:

TheProducts1:=@Trim(@ReplaceSubstring(TheProductsFull;

TempProduct2:

TempProduct3:

TempProduct4:

TempProduct5:

TempProduct6:

TempProduct7:

TempProduct8:

TempProduct9:

TempProduct10:

TempProduct11:

TempProduct12:

TempProduct13:

TempProduct14:

TempProduct15:

TempProduct16:

TempProduct17;“”:“”:“”:“”:“”:“”:“”:“”:“”:“”:“”:“”:“”:“”:“”:“”:“”));

TheProducts:=@Trim(@ReplaceSubstring(TheProducts1;@Char(28);“”));

@If(@IsError(TheProducts);“Database Error”;“”:TheProducts)

This first combobox is set to editable with Refresh choices and refresh fields set. This works as it pulls in the choices.

Now there is another combobox underneath with the following formula:

TheProducts1:=@Trim(@ReplaceSubstring(TheProductsFull;

TempProduct1:

TempProduct3:

TempProduct4:

TempProduct5:

TempProduct6:

TempProduct7:

TempProduct8:

TempProduct9:

TempProduct10:

TempProduct11:

TempProduct12:

TempProduct13:

TempProduct14:

TempProduct15:

TempProduct16:

TempProduct17;“”:“”:“”:“”:“”:“”:“”:“”:“”:“”:“”:“”:“”:“”:“”:“”:“”));

TheProducts:=@Trim(@ReplaceSubstring(TheProducts1;@Char(28);“”));

@If(@IsError(TheProducts);“Database Error”;“”:TheProducts)

This combobox (as you can see is a little different regarding the TempProduct) is set like the first EXCEPT that it is computed and has a hide code of not to show if there’s nothing in the first combobox.

The formula basically takes out of the listed products what the user picked in the above combobox to eliminate a duplicate entry.

There are also hidden temp fields that the formula uses.

Problem:

When the user picks a product from the first combobox it populates and the 2nd combobox shows up but with no products listed (which it should because it works in ver 7). In fact if I click on the dropdown arrow nothing happens.

As I said above this is working fine in ver 7.

Possible bug?

Thanks for any insight and help anyone can give,

Kenny