Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Easy Question
Message
General information
Forum:
Visual FoxPro
Category:
Forms & Form designer
Title:
Miscellaneous
Thread ID:
00095727
Message ID:
00095962
Views:
27
>At 1st combobox InteractiveChangeEvent issue the following:
>
>Thisform.cState_name = This.Value
>Thisform.2ndCombox.Requery()
>
>Your 2nd ComboBox should have the following SQL:
>
>SELECT states.username, st_name FROM states WHERE states.st_name = Thisform.cState_name INTO cursor ComNames
>
>For Correct DisplayValue of the 2nd Combobox, the Bound Property should be set to 2 instead of 1 which is the default.


The 2nd Combo-Box will return the Error 'Thisform can only be used in a Method'
for your reference to thisform.cState_name in the SQL Statement. I have worked
around the problem like 1000 times but was wondering what was the 'right' way.

Thanx!
Bob :-)
Previous
Reply
Map
View

Click here to load this message in the networking platform