error: this operation violates your permissions configuration

[#1]

Hello: I have a form with a dropdown list and 4 text fields.



The dropdown list has 3 values (Committee 1, Committee 2, and committee 3)



In access 2007 I have a database with the names of the people on each committee.



The following code is on the exit button of the dropdown list:



$sourceSet.TIMSTEST.#command.query.commandType = "text"

$sourceSet.TIMSTEST.#command.query.select.nodes.item(0).value = Concat("Select * from Tmp_Committee where Description = '", this.rawValue, "'")

$sourceSet.TIMSTEST.open()

//xfa.host.messageBox("TIMSTEST opened")



$sourceSet.TIMSTEST.close()

//xfa.host.messageBox("TIMSTEST closed")



When I open the form I automatically get the first record in the database.

When I choose another value in the dropdown I get this error:



error: this operation violates your permissions configuration



Please help.



Thank you

[#2]

Have you been able to resolve this issue. I have exactly the same when I am trying to pass any SQL statement. Please help !!!

[#3]

When you set up the connection in the dataview you must choose the delayed open option. It is a checkbox on the bottom of the last screen on the wizard. If youdo not check this off the connection is established when the form is opened and the 1st reord is returned (by default). By delaying the open, you can set your commands (like in your script) then when you do the open then you wil get the correct record.

[#4]

Even after i check the Delay Open check box i get same error

xfa.sourceSet.DataConnection.#command.query.commandType

= "text"

I get same error after adding above line

any help would be appriciated

[#5]

In Form Properties/Default there is a target version ...what is it set to?

Paul

[#6]

i dont see target version in form properties/default....i see it under fprm property/info

8.0.1291.1.339988.308172

[#7]

That number is the version of Designer. If you look under the File menu/Form Properties/ Defaults Tab - the 1st option is a target version of the client that you are designing for.

Paul

[#8]

Thank you for your response,Paul

Am attaching screen shot of my Default tab for your reference

Am designing this form to create mailing labels.

Please let me know if i can get any info about this on this forum

Thank You

DefaultsTab.pdf ‏17 KB

[#9]

This tells me you are using version 8 of Designer ...yes? Are you using Reader to view the form?

Paul

[#10]

yes, Paul