why can't i use a combobox selected item with a question event?

i constructed the question event to fire whenever the user chooses an item from a combobox. and this works....it does fire off a postback event. but i can NOT use the selected item in a sql statement to populate another field.

for example....

this doesn't work:

SELECT [ProductID] AS DefaultValue
  FROM [Fruits].[dbo].[aspdnsf_Product]
  where Name = $(ProductList_Text)

and this doesn't work:

SELECT [Name] AS DefaultValue
  FROM [Fruits].[dbo].[aspdnsf_Product]
  where ProductID = $(ProductList)

and this doesn't work either:

SELECT [Name] AS DefaultValue
  FROM [Fruits].[dbo].[aspdnsf_Product]
  where ProductID = '$(ProductList)'

but THIS works:

SELECT [ProductID] AS DefaultValue
  FROM [Fruits].[dbo].[aspdnsf_Product]
  where Name = 'Apples'

which tells me that i can NOT access the selected item in the combobox even though the manual says that accessing combobox items is accomplished like this:

"Tokens that include the _Text property such as $(ComboBox_Text)..."  - (bottom of page 180 of the users manual)

 

 

Assign the value of a hidden field with the selected value from the combo box. Then use the value of the hidden field.

i guess i don't understand.......

are you saying create another question event and have it trigger off of the selection of an item from the combobox and save the selected value to the hidden field and then change my current question event to pull the token from the hidden field?

if so.......

how do i assign the chosen item to the hidden field? i don't see a way to do that in a question event

also....if i can grab the selected value from the combobox to assign it to the hidden field.....why can't i grab it to use it in the sql?

I do not know why either... this is just what I had to do to get it working.

Question1: Combo Box
Question2: Hidden Checkbox List
HiddenQuestion3: value_of_question1

Question2 default value is SQL driven -- select whatever as QuestionOption, whatevervalue as QuestionOptionValue from whereever where condition_field in ('$(HiddenQuestion3)','$(Question2)')

Question Event 1: When Question1 is selected, unhide Question2
Question Event 2: Set default value of HiddenQuestion3 to be value selected in Question1


I honestly don't know why it had to be done that way, it is just what worked for me.

this is the part that throws me:

Question Event 2: Set default value of HiddenQuestion3 to be value selected in Question1

question1 is a combobox......and the whole issue i'm trying to solve is how to grab the selected item from a combobox

so this is kinda circular

i simply can not grab the selected value of a combobox - let alone assign it to another field.

know whut i mean vern?

i am not sure why you are unable to do that... I have this working in several forms.

Is the sort order correct for the Questions (Sort order, not same as how they appear in order on the page)?

how do you assign a combobox's selected value to another field???

where is that done?

 

HI, use client side javascript for this. Let's say your combobox shortname is "combo". And your other field is "field2". In the client side event of your combobox, type in:

$(field2) = $(combo);

-- David