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.
Expand|Select|Wrap|Line Numbers
- 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
Expand|Select|Wrap|Line Numbers
- 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