根据几个表中的查询查找记录集 [英] Find Record Set Based on a Query from several tables

问题描述

大家好，


无法找到这个问题的答案，我相信这是一个简单的问题，但此时它已经逃脱了我。我做了一个查询，从不同的表中提取相关记录。它工作得很好，但是，我需要创建一个表单，用户在查询中查找与用户选择的特定工单号有关的所有记录。


这是我的查询;

Hello Everyone,

Cant find an answer to this one, which I am sure is a simple issue, but at this time it escapes me. I have made a query which pulls related records from different tables. It works great, however, I need to make a form where a user finds all records in the query pertaining to a specific workorder number chosen by the user.

Here is my query;

展开 | 选择 | Wrap | 行号

推荐答案

好吧也许是另一种方法。


我从上面的查询中为[wo / wri]字段创建了一个带有组合框的表单。现在我创建一个查找按钮，并尝试生成一个宏，根据组合框中的用户输入从查询中查找相关记录。不幸的是，我不知道在宏构建器中如何处理这个问题。如何将宏指向该字段？

Okay maybe a different approach.

I created a form with a combo box for [wo/wri]field from the above query. Now I make a find button, and try to generate a macro to find related records from the query based on the user input in the combo box. Unfortunatly I have no idea what to do in the macro builder with respect to this issue. How do I point the macro to the field?

早上好，


我问的是正确的问题吗？或者这是一个如此简单的答案，我需要继续挖掘？

Good morning,

Am I asking the right question? Or is it such an easy answer that I need to keep digging?

对不起，


忘了包含Access 2003版本。

WinXP Pro。

Sorry,

Forgot to include Access 2003 version.
WinXP Pro.

这篇关于根据几个表中的查询查找记录集的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！