>hi all
>
>2 hours searching UT, this is the most aprox. reply to my search.
>I need to do exactly this:
>A combo, linked to a table (recordsource), with his list filled from another table... this is normal..., BUT:
>
>- The recordsource´s value may not be in the list, and MUST be displayed (standard combo box does not do it).
>- The user can choose some item from the list, but he can also write some different, the controlsource must be refreshed( the combo again does not do it by default )
>
>I can not figure out when and where test the displayvalue#value and refresh the data in recordsource!!
>
>Some ideas???
The key is not to use the standard controlsource property, but your own controlsource property: cControlSource, or something like that. In the control's refresh, you can put: THIS.DisplayValue = EVAL(THIS.cControlSource).
If you need to save the type value to the rowsource, you have to use the lostfocus or valid events to search the items in the list for one that matches the displayvalue, if it is not present, add it using APPEND, and Combo.Requery().
Erik Moore
Clientelligence