updating data grid values

I have a datagrid with 3 columns. The program loops through and subtracts the value in column 3 from column 2 and puts the answer in column 1 until it reaches the end of the file.

The problem is, it doesnt actually put the answer in column 1, or at least it is not visible. How do I get Vb to show the result of the caluculation in the columm?

thanks in advance.

Code:

---

DBGrid1.Columns(2) = DBGrid1.Columns(5) - DBGrid1.Columns(3)
records.MoveNext

---

I just want the answer to actually be visible in columns(2)

can someone help me please?

thanks

can anyone please hlep with this problem?

I did this where col 3 = col 1 + col 2
while numbers are being entered

Code:

---

Private Sub DBGrid1_AfterColEdit(ByVal ColIndex As Integer)
    Dim s!
   
    With DBGrid1
        .Col = 0
        s = Val(.Text)
        .Col = 1
        s = s + Val(.Text)
        .Col = 2
        .Text = Str$(s)
 
        Select Case ColIndex
            Case 0: .Col = 1
            Case 1: .Col = 0
        End Select
    End With
End Sub

---