Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Combobox Update
Message
 
To
22/03/2004 17:48:28
General information
Forum:
Visual FoxPro
Category:
Other
Title:
Miscellaneous
Thread ID:
00888684
Message ID:
00888754
Views:
19
If I understood you right You want when you select the Branch office from first combo the second Combo populate ONLY That branche Loan officers. If So there is a to ways:
1) In InterActiveChange event of the First combo:
SELECT LoanOff
c_filt = "LoanOff.BrancField = '"+this.Value+"'" &&You must Transform the value if it is a numreic
SET FILTER TO &c_filt
thisform.SecondCombo.Requery()
2) You can use put RowSourceType=3 SQL Statement for the second Combo & do something like this in InterActiveChange event of the first Combo:
thisform.SecondCombo.RowSource = "SELECT * FROM LoanOff WHERE LoanOff.BranchField = '"+this.Value+"' INTO CURSOR cLoan"
thisform.SecondCombo.Requery()
HTH
Against Stupidity the Gods themselves Contend in Vain - Johann Christoph Friedrich von Schiller
The only thing normal about database guys is their tables.
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform