Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Combo Box problem
Message
From
07/07/1999 18:36:48
 
 
To
07/07/1999 15:38:58
General information
Forum:
Visual FoxPro
Category:
Forms & Form designer
Miscellaneous
Thread ID:
00238355
Message ID:
00238588
Views:
13
>I made a few modifications and this works. The only thing I wish I could do is sort the list in alpha order but I guess I have to stick to my key sequence.
>
>THISFORM.CodeFrame.SponsorPage.SponCatCbo.RowSource=""
>THISFORM.ExeSQL("SELECT cSpCatName FROM SponCategory","Q_SponCat",1)
>THISFORM.CodeFrame.SponsorPage.SponCatCbo.RowSource="Q_SponCat"
>THISFORM.CodeFrame.SponsorPage.SponCatCbo.Refresh
>
>/Chris

Change your select statement to:

THISFORM.ExeSQL("SELECT cSpCatName FROM SponCategory ORDER BY cSpCatName","Q_SponCat",1)
Craig Berntson
MCSD, Microsoft .Net MVP, Grape City Community Influencer
Previous
Reply
Map
View

Click here to load this message in the networking platform