Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Multiple Combo Boxes With Filters
Message
 
 
To
15/07/1998 13:48:23
John Goodrich
John A. Goodrich & Associates
San Jose, California, United States
General information
Forum:
Visual FoxPro
Category:
Other
Miscellaneous
Thread ID:
00117252
Message ID:
00117953
Views:
12
>Jess,
>I deleted the combo boxes from the form and used the addobject
>in the init section of the grid to add the combo box. Now I need
>to work on getting the filters back in somehow, and changeing
>the current control back & forth from combo to text. I am a little
>confused at which point the CurrentControl changes. I guess I'll play
>with it a awhile.

Why the need to delete the combo box then add it again? You can drop as many controls as you want (realistic ofcourse) on each column and play with them through CurrentControl property.

You can have this code at AFTERROWCOLCHANGE Event of the GRID:
IF This.ActiveColumn = 2  &&When you are at Column 2
   WITH This.Column2
      DO CASE  && Conditions depending on your approach 
      CASE option = 1
         .CurrentControl = "TextBox1"
      CASE option = 2
         .CurrentControl = "Combo1"
         .Combo1.Requery()
      CASE option = 3
         .CurrentControl = "Combo2"
         .Combo2.Requery()
      ENDCASE
   ENDWITH
ENDIF
If notice the REQUERY for Combo Controls, my suggestion is to use SQL as combos rowsourcetype property.
JESS S. BANAGA
Project Leader - SDD division
...shifting from VFP to C#.Net

CHARISMA simply means: "Be more concerned about making others feel good about themselves than you are in making them feel good about you."
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform