Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Selecting items from combo box
Message
De
16/09/1999 04:49:23
 
 
À
15/09/1999 22:04:29
Information générale
Forum:
Visual FoxPro
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Divers
Thread ID:
00265316
Message ID:
00265357
Vues:
19
Hi Mary-Ann.

>Have two variables that a grid uses to display records with a view.
>Have a combo box that has three columns, ProductName, ItemNumber and RevisionNumber, which is where the two vars come from. I want the second and third column values:
>Var1=thisform.combo1.list(thisform.combo1.listindex,2)
>Var2=thisform.combo1.list(thisform.combo1.listindex,3)
>I don't think I understand the list/listindex because the refresh that calls the requery is not getting the two vars, or so it seems.

I notice that columns 2 and 3 of your combo have the word 'Number' in them. Does this mean that they are actually of numeric data type and that you need a number to requery your view? If so, you need:

Var1=VAL(thisform.combo1.list(thisform.combo1.listindex,2))

because the all the items in the list are stored in character format.

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

Click here to load this message in the networking platform