Hi all.

I have a datagrid (datagrid1) that has rows with the following data: Carrier, UpdateFreight (it's a checkbox), Notes

I want to be able to edit only the rows that have ACTIVE Carriers (that information is found in another table myCarriers), if the row contains a Carrier that is INACTIVE then do not allow the user to edit that row (i.e. fill in or clear the checkbox or add notes).

SLX LAN 7.2.1

Thanks!

The grid has events associated with it - the one you need is OnRowSelect.

Simply test the grid row:

Function yourDataGridEditing(Sender, PrimaryKeyValue, FieldName, Value)

If uCase(yourDataGrid.GetCurrentField("CARRIER")) = "INACTIVE" then
  yourDataGridEditing = False
Else
 yourDataGridEditing = True
End If

End Function

Thanks Mike.

I looked at the events available and I didn't find the "BeforeEdit" event, there was however an "OnEdited".

Below is the code I used, I tried making 2 of the columns (which are checkboxes) readonly but it's not working:

Function DataGrid1Edited(Sender, PrimaryKeyValue, FieldName, Value)

If Datagrid1.GetCurrentField("CARRIER") = "INACTIVE" then
datagrid1.Columns.Item(1).ReadOnly = True
datagrid1.Columns.Item(2).ReadOnly = True
Else
datagrid1.Columns.Item(1).ReadOnly = False
datagrid1.Columns.Item(2).ReadOnly = False
End If

Disregard my previous post, I got it to work as you suggested by using the "OnRowSelect" event.

Thanks Mike!