Expand Combo Box Values

[Bombshell Disaster]

Hi there..

Got me stumped, sure it is so simple.. I want to expand the values in a combo box when users are entering data, so that they can view multiple companies with the same name and different cities and then add new companies if not exisiting.

This is the same as when you press ALT+Down Arrow when entering a combox box to completely expand, although I want to do it through VBA.

Any help guys? Cheers..

 

[Bombshell Disaster]

No Worries.. A property not used before, as below.

Figured that conundrum..

Me![YourComboBoxName].Dropdown

 

[missinglinq]

It's always more satisfying to figure it out yourself!