Or you could have used the single line I gave you earlier. That way you wouldn't have needed to SetFocus to the listbox first:
Me.List1.SetFocus Me.List1.ListIndex = MyList.ListIndex + 12
In either case, you will still have the problems I pointed out earlier:
Me.List1 = Me.List1.ItemData(Me.List1.ListIndex + 12)
SELECT * FROM SOMETABLE WHERE column = "some_value"