VB Code:
Private Sub Command2_Click() Rem fetch Me.List10.RowSource = "" rst.Open "select * from Qns_Table", cn rst.MoveFirst Do While Not rst.EOF Me.List10.AddItem rst!QnsID 'Me.List10.AddItem rst!Question rst.MoveNext Loop rst.Close End Sub
is there anyway that i can have my QnsID and Question displayed in seperate column of the List10 (list box)?
i've tried something out of the world and here goes...
Me.List10.Column(0).AddItem rst!QnsID
Me.List10.Column(1).AddItem rst!Question
of course, it isn't suppose to work =P
can someone advice me on this?
Thanks
Astro




Reply With Quote