使用'Like'在子表单中搜索Combobox中的结果 [英] Searching results in Combobox in subform with 'Like'

问题描述

我有一个包含子表单的表单。在子表单上显示了组合框。它包含500多个项目。我想让用户找到包含输入字母的结果。 （例如，当输入for时，结果努力，福特和因此应该显示）。


因此在组合框的属性中我用它作为行源：

Hi,

I have a form with a subform. On the subform a combobox is shown. It contains over 500 items. I want to offer the users to find results containing the entered letters. (Eg. when entering "for", the results "effort", "ford" and "therefore" should be shown).

So in the properties of the combobox I use this as the rowsource:

展开 | 选择 | Wrap | 行号

推荐答案

使用对其他对象的引用直接在SQL中工作时经常出现问题（而不是在VBA中构建SQL时）。


尝试：

Working with references to other objects is often a problem when working directly in SQL (Rather than when building up SQL in VBA).

Try :

展开 | 选择 | Wrap | 行号

当然这可以完成。

但是，据我所知，不是使用组合框。

我可以给你一个基于文本框和列表框的解决方案如果你同意这种方法。

Certainly this can be done.
But, as far as I can think, not by using a combo box.
I can show you a solution based on a text box and a list box if you agree this approach.

ComboBox就是RowSource连接到Mihail的东西。基本上它显示了过滤器的结果。我们不知道过滤器的来源，因为问题（相当奇怪）并没有包含这些信息。我希望它是一个来自Merlyn 所具有的TextBox控件。目前还不清楚这个控件是在主窗体还是子窗体上，这肯定是这个问题的重要信息。


从你的帖子中，我怀疑你'我对这个问题有些误解（这并不是太令人惊讶，因为它在很多方面都不清楚 - 另一个非英语的海报，所以它是可以理解的（虽然错过重要信息不太容易理解）因为这不取决于一个人说的语言））。

The ComboBox is what the RowSource is connected to Mihail. Essentially it shows the results of the filter. We don''t know the source of the filter as the question (rather strangely) didn''t include that information. I would expect that to be a TextBox control from what Merlyn has said. It''s also not clear whether this control is on the main form or the sub form, which would certainly be important info for the question.

From your post, I suspect you''ve misunderstood something about the question (which isn''t too surprising as it isn''t clear in many respects - another non-English-speaking poster, so it''s quite understandable (Although missing out important information is less understandable as that doesn''t depend on which language one speaks)).

这篇关于使用'Like'在子表单中搜索Combobox中的结果的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！