组合框搜索和选择 [英] Combobox Search and Select

查看:80
本文介绍了组合框搜索和选择的处理方法,对大家解决问题具有一定的参考价值,需要的朋友们下面随着小编来一起学习吧!

问题描述

请参阅随附的ms访问文件。

我想要搜索一个组合框并在其中选择一个关键字。通常组合框给你一个关键字的设施开始。例如,我想看到水这个词。如果我输入水在组合框中,它给出了所有具有单词Water的记录。在任何地方开始,在结束之间。我需要在搜索到的项目记录中进行选择。


我该怎么做才能获得帮助。



See the attached ms access file.
I have one combobox I want to search and select a keyword in it. usually combobox give u facility of one keyword which start with. for example I want to see the word "Water" if I type "Water" in combobox it give all the records which have word "Water" anywhere start, between ot end. and I need to select in the searched item record.

how can I do it plz help.

附加文件
testdb.zip (103.3 KB,773 views)
Attached Files
testdb.zip (103.3 KB, 773 views)

推荐答案

作为一个一般来说,除非他们要求,否则这里的专家不会打开新人的附件。如果你可以提供组合框的行源(在属性窗口中),我们可以从那里找出它。如果它只是查询的名称,请从查询中发布SQL代码。
As a general rule, the experts here don''t open attachments from new people unless they ask for it. If you could provide the row source (in the properties window) of the combobox, we could probably figure it out from there. If it is just the name of a query, please post the SQL code from the query.


AFAIK你不能在标准组合框中执行此操作。解决方法可能是让列表框显示部分匹配的结果,并让用户从那里进行选择。
AFAIK you cannot do that in a standard combobox. A workaround could be to have a listbox that shows result with a partial match, and let the user select from there.


如果您输入wa,那么您的意思是什么?唯一的结果是Water,Way,Watch等,或者它只是跳到了Wa。字母表的一部分?
Are you meaning that if you type in "wa" the only results are Water, Way, Watch, Etc. or that it just jumps to the "Wa" portion of the alphabet?


这篇关于组合框搜索和选择的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!

查看全文
登录 关闭
扫码关注1秒登录
发送“验证码”获取 | 15天全站免登陆