标准表格 [英] Criteria Form

问题描述

我有一个带有2个组合框的表单。我想选择信息并运行报告。我在查询中添加条件时得到的错误是Microsoft Jet数据库无法识别[Forms]！[OPCriteria]！[Combo8]"作为有效的字段名称或表达。我试图只做[县]并让它提示我，但我仍然得到相同的错误，只有微软Jet数据库无法识别[县]"作为有效的字段名称或表达式

I have a form with 2 combo boxes on them. I want to pick info and run the report. the error I get when I put criteria in the query is "The Microsoft Jet Database does not recognize "[Forms]![OPCriteria]![Combo8]" as a valid field name or expression". I tried to do just [county] and have it prompt me but I still get the same error only that "The Microsoft Jet Database does not recognize "[county]" as a valid field name or expression"

推荐答案

无法分辨图片中的内容。你可以从SQL视图发布文本吗？

Can''t tell what''s going on in the pic. Can you post the text from the SQL view?

展开 | 选择 | Wrap | 行号

也许有经验的交叉表查询可以提供一些见解。我唯一能看到的是带有组合的表单需要打开才能运行查询，但我认为如果不是这样会导致不同的错误消息。

Maybe someone experienced with crosstab queries can provide some insight. The only thing I can see is that the form with the combo on it needs to be open to run the query, but I think that would cause a different error message if it were not.

这篇关于标准表格的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！