Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Which methods to populate and keep fresh a list box
Message
De
19/01/2000 03:49:51
 
 
À
14/01/2000 15:06:36
Gail Heineman
Alaska Dept of Fish and Game
Anchorage, Alaska, États-Unis
Information générale
Forum:
Visual FoxPro
Catégorie:
Gestionnaire d'écran & Écrans
Divers
Thread ID:
00318308
Message ID:
00319741
Vues:
17
Hi Gail.

>> Newbie question. I have a form on which I would like the user to select from a combo box (sets scanrun->formchar), and the results from that selection to populate a list box (named formverlist) from which another value (formver) can be selected. <<

Set up the ListBox like this:

RowSourceType = 3-SQL Statement

In the Init of the Listbox set it's RowSource like this:

LOCAL lcRowSource
lcRowSource = 'SELECT Yada, Nada, Blah FROM SomeTable ORDER BY SomeField WHERE SomeTable.SomeOtherField = (This.Parent.Combo.Value) INTO CURSOR SomeCursor'
This.RowSource = lcRowSource
This.Requery()

Then, In the Valid of the combobox, you can put code like this:

This.Parent.List.Requery()

Marcia
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform