Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Using combo box I would like user to be able to to type in
Message
 
 
To
All
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Title:
Using combo box I would like user to be able to to type in
Miscellaneous
Thread ID:
00394473
Message ID:
00394473
Views:
41
custom city.

On a form with a dropdown combo with the control source being a city field in a record. The row source is SQL and I use
"Select name from city order by name in to cursor temp" to fill the combo. They also may type in a city not on the list. What happens is when I bring up the form on a record that had a city not on the list it blanks out the combo instead of showing the value in the city field of the current record. Appearantly if it isn't in the combo's item list it shows blank? Whats up? Is there a workaround? I have tried manually populating the combo with additem and then also adding the custom city but it is much slower and how do i know that the custom item hasn't already been added to the list and add it again without scanning the entire item list (about 400 cities). Anybody got any ideas?
Next
Reply
Map
View

Click here to load this message in the networking platform