Good Morning,
I have finally got it working with the code below. Thanks for all your help!
function CTRL2114_7::OnClick(eventObj)
{ try { XDocument.QueryAdapter.Timeout=240;
XDocument.QueryAdapter.Submit();
XDocument.DataAdapters["MainConnection"]
XDocument.DataAdapters["Submit"] .Submit();
XDocument.UI.Alert("Document submitted successfully.");
eventObj.ReturnStatus = true;
XDocument.SetDirty(false);
XDocument.View.Window.Close(true); }
catch(ex)
{ XDocument.UI.Alert(ex.description);
eventObj.ReturnStatus = false; } }