Information générale
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
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
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