Hello,

I want to have a form in which my customer can select 1 of his addresses (using a combo-box), and then change the details for that address.  (example:  when a customer has multiple shipping addresses, he can select one, then all the details get vissible and he can change the details of that address (the zipcode,street,etc).

So, I made the combo box, which has SQL driven options (the address_id's for that customer).
Then I made several text boxes which are visible after a question-event of the first combo-box:   "Address", "Number",  "Zipcode", "Country", etc.
I cannot get it work to set the defaults for these text boxes, using SQL defaults, like:

SELECT street1 AS DefaultValue FROM tbl_address WHERE address_id=$(ABNAA)

ABNAA is the short name of the first combo box.  When i replace  $(ABNAA)   for a, let's say, the number "3", it works.

Is this also a security restriction you took in case of sql injections ?

(Or do i need to make 2 Forms ?   1 With a Querystring postback  (the address selector)   and  1 with a SQL data binding  (all the address details)  )

(Note:  I am evaluating the Trial version.)

Hi. I think for this to work you would have to make two forms... The reason is (at least in the current version) the 'Default Value' is only rendered during initial form submission and not after question events/post backs. What we really need to add is the ability to allow you to 'Set a default value from SQL statement' for a question event (right now this is a possibility for setting a value with a question event, but not via SQL). Anyway, its on the list...

Also, this is just related to the default value and SQL default value feature, if the field was something that used combo box/radio button or options you could end up doing this as demonstrated in the data dependent dropdownlist.

So, basically for now you can do this if you separated it onto two pages.

-Chad

Chad,

when will this option be available?  Will we also be able to fill a text/html question in a like manner?

Thanks.