VB Code:
  1. Private Sub Command2_Click()
  2. Rem fetch
  3. Me.List10.RowSource = ""
  4. rst.Open "select * from Qns_Table", cn
  5. rst.MoveFirst
  6. Do While Not rst.EOF
  7.     Me.List10.AddItem rst!QnsID
  8.     'Me.List10.AddItem rst!Question
  9.     rst.MoveNext
  10. Loop
  11. rst.Close
  12. 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