Update all records (except one) in subform with for each
I have a main form called Quotations with a SubForm called Agents_Prices
The Agents_Prices subform have a Decision Box field called Go
When a user checks Go in one row of the subform we want to uncheck all the others true values of Go in all the rows in the subform (except the current row)
After consulting the help and this forum I try with this code
if (row.Go)
{
for each row in Agents_Prices
{
Go = false;
}
}
row.Go = true;
But don't work