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..