asked on

ComboBox with boundlist, need to accept text that isn't in the list

I have a combobox whose value and display member are bound to a dataset column... I don't want to constrict the text to the list... in other words, even though the list is bound, i want to allow the user to type in something not in the list (i'm not worried about updating the list in the database, I just need to ensure that the if the user types something not in the list it doesn't get reset when the control looses focus.

ASKER CERTIFIED SOLUTION

RonaldBiemans

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

RonaldBiemans

Or you could try to add the item to the actual table that is bound to the combobox

majnun

ASKER

Hmm...

I suppose I can manually loop thru the bound dataset and set the items row by row... it just seems like a lot of work...

I was hoping there was an easy way to reproduce the LimitToList functionality of a bound combobox in Access.

Anyone else have any ideas?

SOLUTION

angelfeijoo

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

SOLUTION

S-Twilley

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

majnun

ASKER

Thank you all for your suggestions... not what I was hoping to hear, but definately workable. Thanks!