Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Combo Boxes and Control Source
Message
From
09/12/1999 08:36:08
 
General information
Forum:
Visual FoxPro
Category:
Forms & Form designer
Miscellaneous
Thread ID:
00298241
Message ID:
00300923
Views:
20
>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
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform