Skip to Content
Former Member
May 25, 2016 at 07:14 AM

Iam loading item serial numbers into matrix Combo Box with query. I want to filter the comboboxes based on selection


Iam loading item serial numbers into matrix Combo Box. when we select serial number, then after we want to select another serial number in second row it will not show first selected serial number

objMain.objUtilities.MatrixComboBoxValues(objMatrix.Columns.Item("V_2"), "SELECT DISTINCT T2.DistNumber,T2.DistNumber FROM OITL T0 INNER JOIN ITL1 T1 ON T0.LogEntry = T1.LogEntry left outer JOIN OSRN T2 on T1.MdAbsEntry = T2.AbsEntry INNER JOIN OWTR T4 ON T0.DocEntry = T4.DocEntry INNER JOIN WTR1 T3 ON T3.DocEntry = T4.DocEntry WHERE T0.[DocType] = '67' and t4.DocNum='" & objForm.Items.Item("4").Specific.Value & "' and t2.itemcode ='" & objMatrix.Columns.Item("V_0").Cells.Item(pVal.Row).Specific.Value & "'")

after loading when i select one serial number in first row. then want to select serial number for second row in that it will no show first selected serial number.