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