Dropdown list to show subform (newbie first form)

[pmelanson]

I have created a dropdown list when item selected to change sub form to visable and populate fields with data from a sql database. I get data for the dropdown list but when selecting an item from the list I get this error:

Script failed (language is formcalc; context is xfa.[0].form[0].#pageSet[0].state[0].DataDropDownList[0])
script=
var sPropertyName = xfa.event.newText
var sPropertyId = $.boundItem(sPropertyName)

xfa.sourceSet.DataConnection2.#command.query.select =
  concat("SELECT PrintName, Title, SignDate FROM tblState WHERE PropertyID = ",
    sPropertyId, " ORDER BY Title;")

xfa.sourceSet.DataConnection2.#command.query.commandType = "text"

xfa.sourceSet.DataConnection2.open()
xfa.sourceSet.DataConnection2.first()
StateSub.presence = "visible"

Error: Property: 'select' cannot be set because doing so would violate the document's permissions settings.

Help would be very much appriciated! Thanks,

Pat

[Former Community Member]

Here is a blog entry from Stefan Cameron that describes the issue.

Paul

http://forms.stefcameron.com/2006/12/07/better-form-design-with-xfa-25/