Forms :: Filling Lists By Double-click And Combo Box

I'm stuck on a portion of a form that displays members attending and not attending a specific event. I've got some of it working but others not.

1. Removing items from a table and updating a listbox
2. Changing the Event selection from Next Record to a combo box.

The code that I have in the two list boxes are as follows:

Code:
Private Sub Form_Current()
Me!lstNotAttending.RowSource = "SELECT DISTINCT Members.MemberID, Members.txtLname, Members.txtFname FROM Members " & _
" LEFT JOIN MemberEvents ON Members.MemberID = MemberEvents.fk_MemberID" & _
" WHERE MemberEvents.fk_MemberID Is Null OR MemberEvents.fk_EventID <> " & Me!txtEventID & _
" ORDER BY Members.txtLName;"
Me!lstAttending.RowSource = "SELECT Members.MemberID, Members.txtLname, Members.txtFname FROM Members " & _
" LEFT JOIN MemberEvents ON Members.MemberID = MemberEvents.fk_MemberID" & _
" WHERE MemberEvents.fk_EventID = " & Me!txtEventID & _
" ORDER BY Members.txtLName;"
End Sub

The code I have working for adding a member:

Code:
Private Sub lstNotAttending_DblClick(Cancel As Integer)
CurrentDb.Execute "INSERT INTO MemberEvents(fk_MemberID, fk_EventID) " & _
"VALUES (" & lstNotAttending.Column(0) & ", " & Me!txtEventID & ");"

Me!lstNotAttending.Requery
Me!lstAttending.Requery
End Sub

I know the code for removing has to start with REMOVE FROM. I just don't know the syntax.The combo box has no code.I'm assuming the Requery options aren't working properly for the listboxes