MS Access 子表单在表单视图中带有#Error 字段

微软访问 2003。

我在子表单后面有一个查询，其中有如下 sql 语句：

SELECT ClientTotalInvoiceLineItems.*
     , CDate(GetWeekEnding([WeekEnding1],[WeekEnding2],[WeekEnding3],[WeekEnding4],[WeekEnding5],[WeekEnding6])) AS WeekEnding 
     , CapturedInvoices.EnteredInvoiceNo, IIf([forms]![frmClientTotalInvoices]![frmClientTotalInvoicesSub].[Form].[NewRecord]=True,0,Ccur([ContractingFeesSubtotal])) AS Subtotal
     , CCur([GSTAmount]) AS GST, CCur([TotalDue]) AS Total
     , IIf(IsNull([ctlCreated]),'',[ctlCreated] & ' by ' & [ctlCreatedBy]) AS Added 
  FROM ClientTotalInvoiceLineItems 
 INNER JOIN CapturedInvoices
    ON ClientTotalInvoiceLineItems.ctlSourceID = CapturedInvoices.CapturedInvoicedID
 ORDER BY CDate(GetWeekEnding([WeekEnding1],[WeekEnding2],[WeekEnding3],[WeekEnding4],[WeekEnding5],[WeekEnding6])) DESC;

当表单位于新记录上时，我在以 ccur 开头的字段中收到 #error。

正如您所看到的，我尝试在字段上放置 Form.NewRecord 表达式来测试它，但现在当我尝试在表单视图中查看时，MSAccess 崩溃了。

如何消除子表单新记录字段中的#error？

Malcolm

有几种方法可以处理这个问题，但一种方法是先将子窗体的记录源设置为空，然后在主窗体的插入事件后填充记录源。