Information générale
Catégorie:
Gestionnaire d'écran & Écrans
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
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement