Hello everybody.. I have a form in my project, that's having a Grd name MSFlexGrid and a Data1. Besides, it also have a cmdCalculate and cmdExit button. Their codes are below.
Private Sub cmdCalculate_Click()
Dim i As Integer
Dim TAmt As Currency
TAmt = 0
For i = 1 To Grd.Rows - 1
TAmt = TAmt + Val(Grd.TextMatrix(i, 6))
Next
TAmt = Val(txtBudget09.Text) - TAmt
txtBalance.Text = Format(TAmt, "0.00")
End Sub
Private Sub cmdExit_Click()
Data1.UpdateControls
Unload Me
Form7.Show
End Sub
Above are only my descriptions of my form. My real problem is, I need to do some filtering to the Data1 shown in MSFlexGrid (Grd namely), so that it only shows the data of keyword that i need. For example, the keyword "Medical". Do i need to add a Combo1 on the form, and some codings? Could u Geeks plz give me the codes? Plz help me..