Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Which methods to populate and keep fresh a list box
Message
From
18/01/2000 21:31:09
Charlie Schreiner
Myers and Stauffer Consulting
Topeka, Kansas, United States
 
 
To
18/01/2000 20:12:43
Gail Heineman
Alaska Dept of Fish and Game
Anchorage, Alaska, United States
General information
Forum:
Visual FoxPro
Category:
Forms & Form designer
Miscellaneous
Thread ID:
00318308
Message ID:
00319698
Views:
15
>I've got it, finally, by putting
>
>IF USED('formversions')
> USE IN formversions
>ENDIF
>SELECT formver, formvername ;
> FROM fileconstants ;
> WHERE formchar = scanrun.formchar ;
> INTO CURSOR formversions
>
>into the Init event of the formverlist, which has a RowSource of formversions and Rowsourcetype of 6-fields, and the above code plus
>
>THISFORM.formverlist.INIT()
>THISFORM.formverlist.REQUERY()
>
>into the InteractiveChangeEvent of the combo box.
>
>No doubt you were all correct with your various suggestions - Once I started over with a blank form to get rid of accumulated accidental extra stuff that may have been buggering up my previous tries, I made rapid progress. My lesson - fewer events with less code is mo bettah. Thank you all.

No Doubt. :-) Actually, I haven't read everything carefully, but that doesn't stop me from making more suggestions.
THISFORM.FormVerList is really THIS
If you put the SELECT SQL statement in the Requery(), then you'll just have one statement in the InterActiveChange()
This.Requery()

Charlie
Charlie
Previous
Reply
Map
View

Click here to load this message in the networking platform