键入问题时搜索 [英] Search as you type question

问题描述

我有一个搜索表单，其中包含SEARCH AS YOU TYPE功能。


现在，当我双击搜索到的项目时，它会显示主表单，其中包含已保存的所有信息，包括子表单，但它不会直接转到子表单中的特定记录。


例如，在我的主表单中，我可以选择AM，LUNCH或PM


，无论我点击哪一个，它都将作为子表单显示。例如，如果我点击A.M.，那么A.M. SUBFORM将可见。如果单击LUNCH，将显示LUNCH SUBFORM，其余部分将隐藏。


如何将子表单链接到搜索表单，这样如果我只在LUNCH时间点击MR.A的表单，它将打开带有LUNCH子表单的主表单。 />

对不起，我知道这很令人困惑。我希望有人理解我！

谢谢！

I have a search form which has the SEARCH AS YOU TYPE function.

Now when I double clicked on to the searched item, it will show me the main form with all the information that has been saved including the subform but it does not take me directly to the specific record in the subform.

For instance, In my main form, I have an option to choose A.M., LUNCH or P.M.

Accordingly, whichever one I click, it will be visible as a subform. For example, if I click A.M., the A.M. SUBFORM will be visible. If I click LUNCH, the LUNCH SUBFORM will be visible and the rest hidden.

How do I link subform to the search form so that if I click on to MR.A’s form for LUNCH time only, it will open up the main form with LUNCH subform.

Sorry, I know this is confusing. I hope someone understands me!
Thanks!

推荐答案

在打开表单的代码中，使用WHERE参数来筛选记录你想要的。

In your code where you open the form, use the WHERE parameter to filter for the record you want.

抱歉兔子。

我不太明白。

我有setfilter的vb代码。


您的意思是我在其中添加另一行来说明哪条记录？

Sorry Rabbit.
I did not quite understand.
I do have vb codes for setfilter.

Did you mean I add another line to it to state which record?

不是另一行。我假设您正在使用DoCmd.OpenForm来打开表单。该方法有一个参数，您可以使用该参数指定where子句，以便可以将其打开到该记录。

Not another line. I assume you''re using a DoCmd.OpenForm to open the form. That method has an argument that you can use to specify a where clause so you can open it to that record.

这篇关于键入问题时搜索的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！