Information générale
Catégorie:
Codage, syntaxe et commandes
JD,
Real close. Try:
Thisform.txt3.Value = thisform.c11.value * thisform.c21.value
The 2nd (bound) column is stored in the Value property.
Rick
>i have a 2 column combo box, column 2 is bound.
>my row source is the following format:
>boardsize, multiplier, boardsize, multiplier
>my row source is exactly:
>2x4, 196, 2x6, 128, 2x8, 96, 2x10, 80
>rowsourcetype is value.
>
>basically, when a boardsize is chosen, i want to use the multiplier in column 2 to be used in mathematical functions. for example, if 2x4 is chosen, then 196 would be placed in the math function. what i'm getting now is a multiplier of 2. i can see why, but how do i avoid the problem?
>
>this is the code i'm trying to use.
>Thisform.txt3.Value = val(thisform.c11.Displayvalue)* val(thisform.c21.Displayvalue)
>
>thisform.c21.displayvalue is what i'm using to reference the multiplier, but it's my guess that displayvalue is not what i should use. can somebody help me out?
>
>thanks,
>JD
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