Private Sub Command2_Click()
Rem fetch
Me.List3.RowSource = ""
rst.Open "select * from qns_table", cn
rst.MoveFirst
Do While Not rst.EOF
Me.List3.AddItem rst!qnsID & ";" & rst!question & ";"
rst.MoveNext
Loop
rst.Close
End Sub

Hello there, i have this command2_click to view all my data in a listbox.
upon inserting my new record, i'll like the listbox to be refreshed. is there anyway i can "CALL" my Rem fetch? or do i just reuse the codes at where i insert the new record?

Thank You

Astro