perfect thanks

Thanks radzmar, but that does not appear to work for me?

This works fine, but I now need to make a subform visible when a particular engine selection is made.Because there are no list items (as they are in the script object) is makes it hard to set an action on the engine ddlist to make the subform visible?I was hoping to do something like:if (xfa.event.n...

Thanks Steve, that exactly what I was trying to do.

Anyone?I have a feeling that I need to add somthing like this on the ddlist?if (Len(Ltrim(Rtrim(SelectField.rawValue))) > 0) then    //Change the commandType from TABLE to TEXT.  TEXT is the equivalent of SQL Property    $sourceSet.DataConnection.#command.query.commandType = "text"    //Set the Sele...

"Is there a way to only lock certain types of objects"If you wrap the objects you want to lock into a subform, and use the name of the subform in the call to the scriptobject, instead of form1.This will give you total control of which items are locked and which are not locked.It works well.

Thanks Niall, that helps a great deal. I now understand where I went wrong!

Paul posted an example of this, here:http://forums.adobe.com/thread/341252?start=150&tstart=0http://forums.adobe.com/servlet/JiveServlet/download/2689916-41209/Lock%20All%20Fields_Purchase%20Order.pdf

Sorry, I had not published it!https://acrobat.com/#d=LgnXPZacCClFizup1g0Q8A

Thanks, your example works great.However, I tried to do this myself without using a table, and am still having problems summing up the total cost value?Not sure what I am doing wrong?https://acrobat.com/#d=LgnXPZacCClFizup1g0Q8A