View Single Post
 
Old 02-28-2020, 08:46 AM
Damiano Damiano is offline Windows 10 Office 2016
Novice
 
Join Date: Feb 2020
Posts: 1
Damiano is on a distinguished road
Default

Not to resurrect a dead thread, but this has been the only useful resource I've managed to find on the topic at hand. Running either the original script in post #2 & the modified ADODB version from gmaxey, I get the same run-time error at the DropdownListEntries.Clear -> DropdownListEntries.Add section:

Quote:
Run-Time Error '6215':

An entry with the same display name already exists - each entry must specify a display name.
When I debug, the "add" entry is always highlighted as the source of the issue, and I'm afraid I'm just not experienced enough in VB to understand why. A cursory google search also doesn't seem to bring up the error, so I've got nothing. Any ideas?