级联组合框过滤 [英] Cascading Combo Box Filtering
问题描述
{主持人编辑}
我已将此劫持帖子移至新主题。请不要用自己的问题接管现有的帖子,因为这是一种应受惩罚的罪行。
最初拍摄的原始帖子可以在如何过滤组合框中的项目列表选择另一个组合中的项目。
{/主持人编辑}
好的,我更改了FROM语句,但仍然被标记。现在是.RowSource。 &安培; FROM线具有红点,并且WHERE有一个带有黄色箭头的红点。
这是否有意义???
此外,当我将鼠标悬停在那些上方时三行,鼠标下方出现一条消息(一种帮助提示)。它说:我!部门= 4 。
{Moderator Edit}
I have moved this hijack post to a new thread. Please do not take over an existing thread with your own questions as this is a punishable offense.
The original thread, from where this was originally taken, can be found at how to filter list of items in a combo box by selecting items in another combo.
{/Moderator Edit}
OK, I changed the FROM statement, and am still getting flagged. Now the ".RowSource" & the "FROM" lines have red dots, and the "WHERE" has a red dot with a yellow arrow.
Does that make sense???
Also, when I hover the mouse anywhere over those three lines, a message (sort of a help tip) appears below the mouse. It says: Me!Department=4.
推荐答案
你的screenshot1中的代码与你在帖子中提供的代码不匹配# 4。请使用复制/粘贴(并使用代码标签, [CODE /] 按钮)发布您所拥有的内容,以便我们可以准确地看到您正在使用的内容。
我在截图中看到的是你的SQL代码从你的表中选择[Combo26]。我的猜测是没有一个名为Combo26的字段会导致错误。
The code in your screenshot1 doesn''t match the code you provided in post #4. Please post what you have using Copy/Paste (and please use code tags, the [CODE/] button) so that we can see exactly what you are working with.
What I''m seeing in the screenshot is that your SQL code selects [Combo26] from your table. My guess is that there isn''t a field called Combo26, which would cause an error.
对不起!我发现[Combo26]不正确后我更改了它。
这是我现在使用的代码:
Sorry about that! I changed it after I found that [Combo26] was incorrect.
Here is the code as I am using it now:
为了便于排除故障,我们可以将SQL代码分配给变量。
Just for troubleshooting purposes, lets assign your SQL code to a variable.
这篇关于级联组合框过滤的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!