Hi,

I’m using VB 2005 and SQL Server 2005.

I have a ComboBox which displays data from a table. It displays colours, like red, green and blue.

What I would like to do, is if the user puts a colour in the ComboBox which doesn’t exist in the table, it asks the user if they want to add this colour to the table.

So if the user keys black and black is not a choice in the ComboBox, it adds black to the table.

Does anyone have a sample app showing this working ?

Thanks so much. Any help much appreciated.

Thanks,

What I have always done is in the AfterUpdate event handler for that combo box, I put a piece of code that inserts the color into the table, (assuming there is a unique key on color in the table.)
Literally you use an INSERT statement in SQL. The best way to do this is to make an Insert stored procedure, and pass the new color as a parameter to that stored procedure. This puts database code in the database where it belongs, instead of coding SQL statements in the form control event handlers. Be sure to handle any errors raised by SQL server in your code, just in case the insert fails.

~ Shaun