>I have never really gotten a dropdown combo to work correctly when the user enters something other than selecting what's in the list. I have a dropdown comboa with .controlsource=Job_Info.Quoted_By and it is populated by a comma delimited list of employee names, but I want to be able to enter something not in the list. When you enter you own text, it doesn't appear in the list, and I can't get it to save the info to the table.
>
>Please help.
When you enter something into text portion of combo you actually populate Combo.DisplayValue property. The next step you have to add (if you want) this entry to the list portion (rowsource) programmatically, e.g.
if this.displayvalue<>this.value
Insert into table1 Values(...)
This.requery
endif
Edward Pikman
Independent Consultant