Dear Niall,It works! Thanks for that.Rgds.

I got a dropdownlist box field and pre-list some numeric values on it :say a list of page numbers,11223341424352..I put some codes on change event so that once an item is clicked, it will be directed to the specific page immediately.But the case is some users would like to enter the field and type a...

Paul,Close connection can release the lock, thanks for that.

Dear Paul,I simply write these codes :xfa.sourceSet.DataConnection.open();xfa.sourceSet.DataConnection.first();while not EOF{    do something ...     xfa.sourceSet.DataConnection.next();}I see your words.ie. There is no way the file must get locked unless I execute xfa.sourceSet.DataConnection.close...

Dear Paul,So do you mean there is no way that the Excel file will keep locked whenever a connection is not closed?I just wonder if I can still open and edit the spreadsheet in Office if the connection is still not closed,Rgds.

I create an OLEDB data connection with Excel file on Designer ES2, my form will only need to read this file for data, there is no need to lock it at all.Following is my connection string :Provider=MSDASQL.1;Persist Security Info=False;Data Source=Excel Files;Mode=Read;Extended Properties="DSN=Excel ...

Dear Paul,I see...thanks for that.

On LC Designer, I set up a data connection called DataConnection1 to access a certain file named a001.xls,Here is the xml shows:<sourceSet xmlns="http://www.xfa.org/schema/xfa-source-set/1.0/">   <source name="DataConnection1" db="ado">      <connect delayedOpen="1" timeout="15">         <connectStr...

Thanks Radzmar, it works!Rgds.

but it seems that after event.target.closeDoc(true);the codes that follow will continue to run,but this doesn't happen if I use app.execMenuItem("Close");I already include the closeDoc inside the try catch.