Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Firing an event using a Datagrid

Status
Not open for further replies.

Easler

Programmer
Jan 11, 2002
6
0
0
US
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
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top