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:
00095926
Views:
22
>Can Someone please offer some insight??
>
>In my search for the ever changing correct way to do things..
>
>The Over-Simplified Vesrion:
>
>If I have a combo-box (Referred to as comStates) that contains the Names of States of the USA and this Combo-Box's Control Source is thisform.cState_Name
>
>My Second Combo Box would Contain the users of that state based upon
>the Value of the first combobox. I would do a SQL Statement in the Rowsource of the 2nd comboBox that said something like...
>
>Select * from States where st_Name=thisform.comStates.Value into Cursor comNames
>
>Of course, this will Puke... I was wondering how a more 'Seasoned' approach to this would be??
>
>Thanx Much!!!
>Bob :-)

I'm still a newbie at this myself, but the exact answer you want is in "Programming Visual FoxPro 3.0" by Whil Hentzen on page 408. His on disk example is C23LST3. I'm using what you describe for reportselection, where the first box contains the categories and the second box contains the reports in the selected category. I'd post the code except I don't want to violate the copyright. This is a very nice book with examples of just about everything, and very readable.

HTH, Pete
Peter Adams
FoxPro Programmer
Compu-Mail

Heisenberg was probably right...
Previous
Reply
Map
View

Click here to load this message in the networking platform