Key is already associated with an element of this collection...

[Coleman34]

I am at a loss. I came back from vacation and now this isn't work, when it had been working previously. Can anyone tell me why? (It is still on vacation is not a valid reply LOL) It is failing on this line "DistrictNums.Add CurrentName, CurrentNum" obviously. I am adding a list of congressional districts and their reps, so I may have multiple of "dist 1:Mary smith" relationships that subsequent "dist 1:Mary smith" relationships would just be ignored after they are added the first time. This is where it is hanging up.

Please Login or Register  to view this content.

[6StringJazzer]

What does "failing" mean?

It appears that if there are duplicates in the list, that you want to show the user a message somehow (we don't know what RaiseError does).

So what actually happens?

[The_Prist]

Check: Tools-Optons-General-groupe Error Trapping. Use "Break on unhandled Errors". Now you have probably found "Break on All Errors"

so you can use a dictionary instead of a collection. Error handling when not required.:

Please Login or Register  to view this content.