如何最好地实现我的搜索表单 [英] How to best implement my search FORM

问题描述

大家好，


我基本上想要使用我的顾问/员工数据库，这样我就可以根据经验，提供的服务以及专业知识开展快速搜索。我附上了我的数据库，我想要实现的目标应该从两种形式中看出来。我认为下一个合乎逻辑的步骤是创建一个列表框，显示名称，以及适合我选择的搜索的顾问的联系方式。有人可以帮帮我吗？


非常感谢。


问候，


垫

Hi All,

I basically want to use my database of consultants/employees so that I can launch a quick search by country of experience, services provided as well as expertise. I have attached my database, and what I''m trying to achieve should be apparent from the two forms. I think the next logical step would be to create a list box that would show the name, and contact details of the consultants who fits the search I have selected. Can anybody help me out here?

Thanks alot.

Regards,

Mat

附加文件

Template database.zip （152.0 KB，99 views）

Attached Files

Template database.zip (152.0 KB, 99 views)

推荐答案

您有具体问题吗？

是的。请打开''FORM''或''FORM1''。我想我已成功实施了下拉菜单（专业知识，国家/地区，服务）。从这个表单中，我希望能够在三个下拉框中选择任何工作，然后单击刷新列表按钮，并在另一个框中显示下面的结果。我的问题是：我该怎么做？我不知道如何实现这个盒子，以及如何告诉计算机操作这个搜索。


我希望现在更清楚了。


Mat

Hi,

Yes. Please open ''FORM'' or ''FORM1''. I think i have successfully implemented threre drop-down menus (expertise, country, services). From this form, I want to be able to select any work within the three drop-down boxes, and click on the ''refresh list'' button, and have an additional box showing the results underneath. My question to you is: how do I do that? I don''t know how to implement this box, and how to tell the computer to operationalise this search.

I hope this is now a bit clearer.

Many thanks for the help!

Mat

对不起，我不能在这里下载你的数据库。看起来子窗体比这个函数的列表框更好。您可以使用代码过滤子窗体记录，也可以使用主/子链接字段。

Sorry I can''t download your database here. It seems like a subform would serve you better than a list box for this function. You could use code to filter the subform records, or you could use the Master/Child Link fields.

这篇关于如何最好地实现我的搜索表单的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！