运行时错误"2465"...找不到表达式中'|1'引用的字段

Question

我一直收到消息Run-time error '2465' ...can't find the field '|1' referred to in your expression，不知道从哪里找到原因，请帮忙！

DoCmd.OpenForm "JournalDetailsDrilldown", acNormal, , "SQL_Where" And [Plymouth - Nominal Detail]![Client Ref] = " & Forms!MainMenu![Client Ref] & "

下面的那个正在工作DoCmd.OpenForm"JournalDetailsDrilldown"，acNormal，SQL_Where&"和[Client Ref]="&表单！主菜单！【客户参考】

错误消息已排序，非常感谢雅各布！！1

Answer 1

你可以试试这个：

SQL_Where = "[Date]>=#" & Format([Forms]![MainMenu]![StartDate], "mm/dd/yyyy") _
  & "# AND [Date]<=#" & Format([Forms]![MainMenu]![EndDate], "mm/dd/yyyy") & "#"
DoCmd.OpenForm "JournalDetailsDrilldown", acNormal, , SQL_Where & " And [Client Ref] = " & Forms!MainMenu![Client Ref]

SQL_Where可以替换为合适的SQL，其中字符串的形式为

Columnname = "ColumnValue"

对于表中归档的字符串[Plymouth-标称细节]。或者：

Columnname = ColumnValue

if[Plymouth-标称细节]！列名的类型为数字。