Listbox multiselect and move to another listbox (1 Viewer)

Hi Guys,

Appreciate if you could help me out.
I have listbox4 and listbox5, when i select multiple row from the listbox4 and click next, the issuetbl suppose to update 'Check' in complete column.
So that listbox5 have the item which i selected. Unfortunately, it only show the last item that i selected.

Private Sub btn_Select_Click()
Dim sSQL As String

sSQL = "Update Issuetbl Set [Issuetbl].[Complete] = 'Check' WHERE [Issuetbl].[Serial_Number] = '" & Me.Listbox4.Column(0) & "'"
CurrentDb.Execute (sSQL)

End Sub

Click to expand...

Any idea how to update the table to "CHECK" for the item that i multi-selected in the listbox4?

I have find the solution.