如何生成可更新的视图

一个视图，用来生成一行新数据到表custpayinv表中。

视图acc_InvForReceiving　包含一个视图NewCustPayInv　

SELECT Invoicing.InvoiceID, Invoicing.Orderid, Invoicing.InvoiceDate, Invoicing.Number, ORDER.POCustomer, Invoicing.TotalAmount, Invoicing.InvoiceTerms, PROJECT.CustID, Invoicing.UnPaidBalance, PROJECT.Currence, NewCustPayInv.*, ORDER.InterComp, Company.CompanyName, PROJECT.ProjectName, ITEM.ItemName, PROJECT.Co, ORDER.InternalPO, Invoicing.HKItem, Invoicing.HKShipping, Invoicing.HKTotal, Invoicing.GOVexRate, Invoicing.STDexRate, Invoicing.IntGOVexRate, Invoicing.STDTotal, Invoicing.GOVTotal, Invoicing.GOVintTotal, Invoicing.IntGOVTotal, ORDER.OrderDate, Invoicing.Notes, Company.CompanyName, PROJECT.Currence
FROM (Company INNER JOIN PROJECT ON Company.CustomerID = PROJECT.CustID) INNER JOIN (((ITEM INNER JOIN APPROVAL ON ITEM.QID = APPROVAL.ItemID) INNER JOIN [ORDER] ON APPROVAL.APVID = ORDER.APVID) INNER JOIN (Invoicing LEFT JOIN NewCustPayInv ON Invoicing.InvoiceID = NewCustPayInv.InvoicingID) ON ORDER.OrderID = Invoicing.Orderid) ON PROJECT.ProjectID = ITEM.ProjectID
WHERE (((Invoicing.UnPaidBalance)<>0) AND ((PROJECT.Co)=[forms].[acc_CustPayment].[co]))
ORDER BY Invoicing.InvoiceDate;

视图NewCustPayInv　：

SELECT CustPayInv.CustPayInv, CustPayInv.CustPaymentID, CustPayInv.InvoicingID, CustPayInv.PaidDate, CustPayInv.Currency, CustPayInv.PayAmount, CustPayInv.GOVi, CustPayInv.EURi, CustPayInv.Paid1, CustPayInv.XGOV, CustPayInv.XSTD, CustPayInv.CustPayInvFile, CustPayInv.CurrentCredits, CustPayInv.Item, CustPayInv.Shipping, CustPayInv.VAT, CustPayInv.Others, CustPayInv.exPINVrate, CustPayInv.exPINVrateSTD, CustPayInv.UnBalanceNDL
FROM CustPayInv
WHERE (((CustPayInv.CustPayInv) Is Null));

当ｐ点击时，把ｐａｙｍｅｎｔ等值传入custpayinv表中。

在ｍｄｂ时正常，但是ＡＤＰ报错。

请各位大神指教！