Hi
it's my 1st post in VB,
i'm trying to get data from ComboBox & result with MSHFlexGrid
it's working fine there is no problem
they only thing i need is
Another ComboBox & ( result inside is 5 then ) generate auto
another ( 5 resulted ) ComboBoxs & get result with MSHFlexGrid.
& MSHFlexGrid
everything should be automatic
is any body knows how to do it, thanks in advance for reading & reply
it's my 1st post in VB,
i'm trying to get data from ComboBox & result with MSHFlexGrid
it's working fine there is no problem
they only thing i need is
Another ComboBox & ( result inside is 5 then ) generate auto
another ( 5 resulted ) ComboBoxs & get result with MSHFlexGrid.
Code:
Private Sub ComboBox_Click() rs.Open "select*from tblProduct where Supplier='" & cboSupplier.Text & "'", cn, 3, 3 If Not (rs.BOF And rs.EOF) Then grdProduct.Enabled = True Set grdProduct.DataSource = rs Set rs = Nothing End Sub
Code:
Private Sub grdProduct_Click() i = grdProduct.Row With grdProduct lblItemName.Caption = .TextMatrix(i, 2) scAd = .TextMatrix(i, 1) itmAd = .TextMatrix(i, 2) End With If Not scAd = "" Then cmdAdd.Enabled = True End If End Sub
is any body knows how to do it, thanks in advance for reading & reply
Comment