>>>I have created a combobox based on a single field table. If the user types in a value not in the table they are prompted to add it to the list. If the user selects Yes, then the .DisplayValue is INSERTed into the combobox's source table and REPLACEd in the current record and then a THISFORM.Refresh is issued. This works fine as the new choice is available in the combobox but the value the user typed in dissappears from the screen. Any ideas?
>>
>>Instead of Thisform.Refresh use Thisform.Combobox.Requery() and then reset Combobox.DisplayValue property to show inserted value.
>
>HEY Ed!!! Finally...we agree on how to do a combobox!!! LOL
The best combobox from MS. Beauty, eh?!
Edward Pikman
Independent Consultant