Hi!
This always required additional code in the Valid event of the combobox to save new value manually. The value typed in the textbox portion of the combobox is stored in the DisplayValue property. Beware about its refreshing - it refreshed quite often by many actions with properties and methods of combobox. You can also always add this new item to the combobox list using AddItem or AddListItem methods of combobox - they work for any row source type, data in list is just a copy of data in the RowSourse and updated by Requery method or RowSource change.
HTH.
>I'm using a Combobox where I used to have a Textbox. It is SQL to a cursor, has a view field as ControlSource and is Bound. When I type in new information that doesn't already exists in the results of the SQL it does not save it to the view. IOW, if the SQL returned as list:
>
>A
>B
>C
>
>And I type in B where the old value was an A, or select it from the drop list, it will work. If I type in D for the new value, it will not save.
>
>Any ideas? Thanks!
>
>Regards, Renoir
Vlad Grynchyshyn, Project Manager, MCP
vgryn@yahoo.comICQ #10709245
The professional level of programmer could be determined by level of stupidity of his/her bugs
It is not appropriate to say that question is "foolish". There could be only foolish answers. Everybody passed period of time when knows nothing about something.