A "CALL" method

[Astro]

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

[RobDog888]

You mean you want to execute the rem fetch again or List3.Refresh

[Astro]

Does List3.Refresh actually works? I've tried and it doesn't