I have a many to many relationship that I'm trying to use an append query on:

tblContacts - ContactID (primary key), name, etc...
tblMailingList - ListID (primary key), list name
tblMailingListLINK - ContactID & TableID (one to many relationship from
above tables) and a yes/no field called 'Included'

On my form I'd like to use an append query when a list is selected from a
combo box to add any contacts that may have been added since the last time
the list was worked on.

I've created the append query, but its not ignoring duplicates.  Other posts
say that it should do this automatically... where did I go wrong?

here's the query code:

INSERT INTO tblMailingListLink ( ContactID, ListID )
SELECT tblContacts.ContactID, forms!frmmailinglist.listselect AS ListID
FROM tblContacts
WHERE (((tblContacts.RemoveFromList)=No));

Thanks for reading!