Adding items to a combobox

[srobbins]

In an open event I'm using the additem method to populate a combobox.

The items I'm adding are names that are formatted lastname & ", " & firstname. The embedded comma is causing two items in the list for each name, so my list ends up twice the length it's supposed to be.

Does anyone know a way around this?

 

[MStef]

Hello srobbins!

Look at "DemoLNameFNameComboA2000.mdb".

 

[srobbins]

Thanks! I needed to do this via code rather than setting the Row Source property, but your demo led me in the right direction.