I enter two columns (2 and 3) of information in a datagrid then I run a procedure to set certain fields (0,1) and calculate another(4). What event do I use to keep this procedure from firing until I enter the second column of data?
Private Sub dgAllAmt_AfterColEdit(ByVal col3 As Integer)
strIDNum2 = strIDNum + 1
dgAllAmt.columns(0).Text = strIDNum2
strIDNum = strIDNum2
dgAllAmt.columns(1).Text = strGloAss_Num
If dgAllAmt.columns(2).Text >= 7000 Then
temptot = 7000
Else
temptot = dgAllAmt.columns(2).Text
End If
dgAllAmt.columns(4).Text = temptot + nSum
nTotal = nSum + temptot
nSum = nTotal
End Sub
Private Sub dgAllAmt_AfterColEdit(ByVal col3 As Integer)
strIDNum2 = strIDNum + 1
dgAllAmt.columns(0).Text = strIDNum2
strIDNum = strIDNum2
dgAllAmt.columns(1).Text = strGloAss_Num
If dgAllAmt.columns(2).Text >= 7000 Then
temptot = 7000
Else
temptot = dgAllAmt.columns(2).Text
End If
dgAllAmt.columns(4).Text = temptot + nSum
nTotal = nSum + temptot
nSum = nTotal
End Sub