I have a datawindow(dw_coll_excsel) which has a dropdownlistbox(select_exc_flag). The values of this dropdownlistbox are hardcoded. But on a certain condition, i want to add an item to this dropdownlistbox from the open event of the window. This is what I have given, but i am getting an error. The type of select_exc_flag is Number, but it has display values as strings. How do I incorporate that here.
I want to insert the 17th row with data value as "Acct is coded to rep 96"
This is what I have done:
s = "Acct is coded to rep 96"
IF A = "SUPPLY" THEN