>I have a dropdown combo box that I'm filling with distinct values already entered in a field called en.subject. I want the users to either pick a value someone else has already entered or enter a new one. Picking one off the list works great when I run tableupdate but when they type in different text and save that value just disappears. En.subject is set as the ControlSource. Can someone tell me what I'm doing wrong. I'm sure it's something simple as usual.
>
>Brad
When you type something new in the text portion of combo, you should save Combo.DisplayValue property. You could clear Combo.ControlSource property and have following code in Combo.LostFocus event:
Select En
Replace En.Subject with This.DisplayValue
Edward Pikman
Independent Consultant