Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
ComboBox Requery
Message
 
 
To
21/01/2009 22:30:02
Jay Johengen
Altamahaw-Ossipee, North Carolina, United States
General information
Forum:
Visual FoxPro
Category:
Forms & Form designer
Miscellaneous
Thread ID:
01376163
Message ID:
01376168
Views:
11
>If the RowSourceType is Alias, does the Requery have any affect on the ComboBox? If not, what do you do if it's an alias that was created with SQL elsewhere in the form? Do I have to rerun that SQL? Should I just put the SQL into a new method of the form and call that as needed?

Here is what I do. If I need to re-run the combo's SQL, I first assign combo to the empty string, e.g. RowSource = "", then run my SQL, then RowSource = 'myCursor'

You can put this code in the separate form's method and call when needed.
If it's not broken, fix it until it is.


My Blog
Previous
Reply
Map
View

Click here to load this message in the networking platform