General information
Category:
Coding, syntax & commands
>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
thanks rick, youre a lifesaver.
JD
Previous
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only