从两个有关系的表创建一个表单 [英] Create a form from two table that have relationship

问题描述

大家好。

我有一个数据库，其中有两个名为failure和instrument的表。我从instrument表创建了一个查询，并在查询和失败表之间创建了一个关系。我从故障表（表单A）创建了一个表单。我创建了另一个表单（表单B），它应用表单A中的字段
和失败表中的字段（连接失败表和查询的工具字段）和查询中的字段。另外，表单A有一个打开的命令表格B和我想找到一个特定的数据。它可以打开表格B，当表格B中的
数据输入以后可以找到特定数据。但是当想要在表格B中输入新数据时，找不到具体数据。

I have a database with two table that named failure and instrument.I created a query from instrument table and a relationship between query and failure table. I created a form from failure table (form A). I created another form (form B) that apply a field from Form A and a field from failure table (instrument field that connect failure table and query) and a field in query.Also Form A has a Command that open Form B and i want to find a specific data.It can open form B and can find specific data when the data in form B entered later.But When want to enter new data in form B,can not find specific data.

请帮助我

推荐答案

命令按钮的代码是什么打开表格B？

What is the code you have for the command button to open Form B?

表格B上的OnLoad代码是什么？

What is the OnLoad code you have on Form B?

如何设置关系？

您是否考虑过将表格B作为表格A的子表格？

Have you considered making Form B a subform of Form A?

这篇关于从两个有关系的表创建一个表单的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！