Selection from DDL enters same selection in more DDLs

[mdawn50]

Hello,

I have a table with 6 columns and 5 rows. Each cell is a DDL. If the user selects rawValue == 3 in a cell in a row, the remaining cells in the row need to be set to rawValue 3 automatically.

Any help with the script for this would be appreciated.

Thanks,

MDawn

[_Bruce_Robertson]

Hi,

You can put code in the calculate event of the row, something like;

if (DropDownList1.rawValue == "3")

{

    DropDownList2.rawValue = "3";

    DropDownList3.rawValue = "3";

    .

    .

}

Bruce

[mdawn50]

I put this in the Calculate event of the first DDL and it closed the field from the user entering anything. The other DDLs were fine and open to selecting an option.

Thanks,

MDawn

[_Bruce_Robertson · Accepted solution]

Hi,

If you put code in the calculate event then Designer will assume the user wont be entering anything in that field (though there is a user can override option).

I was meaning this code to go in the calculate event of the row object that contains the dropdown fields, by default called Row1.

Regards

Bruce

[mdawn50]

I did get it to work.

Thank you.

Margaret Dawn