Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Combobox Update
Message
 
À
22/03/2004 17:48:28
Information générale
Forum:
Visual FoxPro
Catégorie:
Autre
Titre:
Divers
Thread ID:
00888684
Message ID:
00888754
Vues:
20
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.
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform