我的表单认为我正在添加记录，我想选择一个进行编辑 [英] My form thinks I am adding records, I want to choose one to edit

问题描述

我是新手，所以我认为这是一个容易回答的问题。我自己找不到它。


背景：


两个表有一对多的关系（irelevantField1是一个占位符，这些字段与发布无关，所代表的字段数是正确的）


包裹：

ParcelNo

irelevantField1

irelevantField2

irelevantField3


属性：

TaxID

irelevantField1

ParcelNo

irelevantField2

irelevantField3


我输入的表格中的数据和在许多其他表格中，我根据查找和输入数据的典型工作流程对表格进行了分组。在ParcelNo已知之前，首先输入属性的数据。


我想从我输入Parcels数据的相同表格中将ParcelNo添加到Properties表中。我构思的表单有一个基于Properties表的子表单（生成向导），我已经包含了TaxID和ParcelNo字段。我包含ParcelNo字段只是为了验证在窗体顶部输入的宗地编号是否在子窗体中使用（它自动填充）。然后我将TaxID框更改为基于Properties.TaxID字段的组合框，作为行源属性中的查询。


这是想要发生的事情与实际不同的地方碰巧，它不会让我选择现有的地块编号，因为它会创建一个重复的记录。它试图在Properties表中创建一条新记录，我希望它从现有表中选择并在字段中输入相应的数字。多个Property将拥有相同的ParcelNo。


任何输入都将受到赞赏。

I am new to access, so I figure this is an easy question to answer. I just can''t find it on my own.

Background:

Two tables with a one to many relationship (irelevantField1 is a place holder, these fields are not relevant to posting, the number of fields represented is correct)

Parcels:
ParcelNo
irelevantField1
irelevantField2
irelevantField3

Properties:
TaxID
irelevantField1
ParcelNo
irelevantField2
irelevantField3

The forms I have enter the data in these and many other tables, I have grouped the tables based on typical workflow for finding and entering the data. The Properties'' data is entered first, before the ParcelNo is known.

I want to add the ParcelNo to the Properties table from the same form I am entering the Parcels'' data. The form as I have conceived it has a subform (wizard generated) that is based on the Properties table, I have included the TaxID and ParcelNo fields. I included the ParcelNo field just to verify that the parcel number that is entered at the top of the form is used in the subform (it fills in automatically). I then changed the TaxID box to a combo box based on the Properties.TaxID field, as a query in the row source property.

This is where what want to happen differs from what actually happens, it won''t let me choose an existing parcel number because it creates a duplicate record. It is trying to create a NEW record in the Properties table, I want it to choose from the existing ones and put the appropriate number in the field. More than one Property will have the same ParcelNo.

Any input would be appreciated.

推荐答案

如果你想更新在表单上有多个表，你需要创建一个可更新的查询来基于表单。

确保查询在进行之前是可更新的，因为这有时很难实现。

如果有这个，你需要将''''数据输入'属性设置为否。当设置为是时，它将不断添加新记录。

If you want to update more than one table on a form, you need to create an updatable query to base the form on.
Make sure the query is updatable before progressing as that is sometimes hard to achieve.
When you have this, you need to set the form''s ''Data Entry'' property to No. When set to Yes, it will continually add new records only.

如果要更新表单上的多个表，则需要创建一个基于表单的可更新查询。

确保查询在进行之前是可更新的，因为有时很难实现。

如果有这个，你需要将表单''''数据输入''属性设置为否。当设置为是时，它将不断添加新记录。

If you want to update more than one table on a form, you need to create an updatable query to base the form on.
Make sure the query is updatable before progressing as that is sometimes hard to achieve.
When you have this, you need to set the form''s ''Data Entry'' property to No. When set to Yes, it will continually add new records only.

我不认为我明白你写的是什么。我知道什么是查询，并且可以在SQL视图中读取基本的查询。你写的内容很可能就在我脑海里。请允许我提出跟进问题。如果我有一个基于属性表中的TaxID和ParcelNo字段的表单，我可以更改所需的包裹编号，它将保存到表中。然后我可以切换到下一条记录并进行更改。


在包裹表格中，我希望能够从所有属性的列表中选择适用于包裹的所有属性，我想我可以通过制作表单来完成此操作我刚刚描述了一个Parcels表格的子表格。


这个评论是否会改变你对我的问题的理解，如果没有，我可以点击这些资源，这样可以让我免受烦恼你自己。一本好书？

I don''t think I understand what you wrote. I know what a query is and can read basic ones just fine in SQL veiw. What you wrote is just likely over my head. Permit me a follow up question. If I have a form based on just the TaxID and ParcelNo fields in the properties table, I can change the parcel number all I want and it will save to the table. Then I can switch to the next record and change it too.

In the Parcels form I want to be able to select all the properties that apply to a parcel from a list of all the properties, and I thought I could do this by making the form I just described a subform to the Parcels form.

Does this comment change your understanding of my problem, and if not is there a resource I can tap that will keep me from bugging people like yourself. A good book?

不是一本书，但有人最近在这里发布了一个链接，我现在已将其添加到我的收藏夹中。

它可以提供帮助。

不幸的是 - 我发现它已经在工作中我添加了它:(

没关系，你可以找到它，如果你可以在这个论坛搜索，否则有人可能会在这里为你发布它。

Not a book, but someone posted a link on here recently which I''ve now added to my favourites.
It could help.
Unfortunately - I find it''s at work that I''ve added it :(
Never mind, you may find it if you can search in this forum, otherwise someone is likely to post it in here for you sometime.

这篇关于我的表单认为我正在添加记录，我想选择一个进行编辑的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！