DataGridView Combobox Refresh/Update - VB.NET 2.0

[Trey]

I have an unbound datagridview with three comboboxes (e.g. A, B, C) All three comboboxes share the same datasource and use the same valuemember. If I change the value of say combobox A, then B and C change also.

My problem is that B and C do not show the update until after I click off of combobox A. I want B and C to update as soon as I make the selection on A. How do I do this?

Thanks,
Trey

 
 Private Sub DataGridView1_CellValueChanged(ByVal sender As System.Object, ByVal e As System.Windows.Forms.DataGridViewCellEventArgs) Handles DataGridView1.CellValueChanged
        If Me.Visible = True Then
            Dim ColumnIndex
 
            ColumnIndex = DataGridView1.CurrentCell.ColumnIndex
 
            If ColumnIndex = 2 Then
                IndexValue = DataGridView1.CurrentRow.Cells(2).Value
                DataGridView1.CurrentRow.Cells(3).Value = IndexValue
                DataGridView1.CurrentRow.Cells(4).Value = IndexValue
            End If
 
            If ColumnIndex = 3 Then
                IndexValue = DataGridView1.CurrentRow.Cells(3).Value
                DataGridView1.CurrentRow.Cells(2).Value = IndexValue
                DataGridView1.CurrentRow.Cells(4).Value = IndexValue
            End If
 
            If ColumnIndex = 4 Then
                IndexValue = DataGridView1.CurrentRow.Cells(4).Value
                DataGridView1.CurrentRow.Cells(2).Value = IndexValue
                DataGridView1.CurrentRow.Cells(3).Value = IndexValue
            End If
 
        Else
            Exit Sub
        End If
 

[Trey]

It has been resolved. The solution was the last event shown starting on line 31.

 Private Sub DataGridView1_CellValueChanged(ByVal sender As System.Object, ByVal e As System.Windows.Forms.DataGridViewCellEventArgs) Handles DataGridView1.CellValueChanged
        If Me.Visible = True Then
 
            Dim ColumnIndex
 
            ColumnIndex = DataGridView1.CurrentCell.ColumnIndex
 
            If ColumnIndex = 2 Then
                IndexValue = DataGridView1.CurrentRow.Cells(2).Value
                DataGridView1.CurrentRow.Cells(3).Value = IndexValue
                DataGridView1.CurrentRow.Cells(4).Value = IndexValue
            End If
 
            If ColumnIndex = 3 Then
                IndexValue = DataGridView1.CurrentRow.Cells(3).Value
                DataGridView1.CurrentRow.Cells(2).Value = IndexValue
                DataGridView1.CurrentRow.Cells(4).Value = IndexValue
            End If
 
            If ColumnIndex = 4 Then
                IndexValue = DataGridView1.CurrentRow.Cells(4).Value
                DataGridView1.CurrentRow.Cells(2).Value = IndexValue
                DataGridView1.CurrentRow.Cells(3).Value = IndexValue
            End If
 
        Else
            Exit Sub
        End If
    End Sub
 
    Private Sub DataGridView1_CurrentCellDirtyStateChanged(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles DataGridView1.CurrentCellDirtyStateChanged
        DataGridView1.CommitEdit(DataGridViewDataErrorContexts.Commit)
    End Sub