＃名称？尝试添加新记录时Access表单中的错误 [英] #Name? error in Access Form when trying to add new record

问题描述

大家好！


我们整天都在研究这个问题，以便为解决方案寻求帮助。


我有一个表格A，只能通过另一个表格B访问（即用户无法直接进入表格A并添加数值）。

因此当用户点击表格B中的按钮时他被带到表格A.

如果表格A有一份记录（CONTAINER）记录表格B中的关键记录，那么根据代码过滤正确的记录：

Hello all!

Have researched the issue all day to to avail, therefore turning to your help for the solution.

I have a Form A which is accessed via another Form B only (i.e. not possible for user to go directly to a Form A and add values).
So when the user clicks on a button in the Form B he is taken to the Form A.
In case Form A has a record (CONTAINER) correspondent to key record in Form B, then the correct record is filtered based on the code:

展开 | 选择 | Wrap | 行号

推荐答案

首先，对于表的字段和表单上的控件使用相同的名称是个坏主意。一种常见的方法是在控件名称前面添加一个tb或txt作为文本框。


首先修复它，并告诉我们是否有帮助。

First of, its a bad idea to use the same name for both the field of the table and the control on your form. A common approach is to prefix the control name with a tb or txt for textbox.

Start by fixing that, and let us know if it helps.

我不知道你究竟指的是什么，因为我有2个表格而且两者中的CONTAINER都是指初始表中的记录，所以我真的无法改变其中的一个，因为它不起作用。 br />

也许你可以更准确地解释一下或者我需要的更多信息吗？

don''t know what exactly yu are referring to as I have 2 Forms and the CONTAINER in both refers to a record in the initial table, so I really cannot change the one of these as then it would not work.

Perhaps you could explain more precisely or some more info needed from my side?

它看起来像两个[表格A]上的控件（哪个似乎是[frmExpense] - 如果您在解释中使用的名称与代码中的名称匹配，则实际上更清楚）和[Form B]（[frmExport]）字段[CONTAINER]也被命名为[CONTAINER] 。访问默认为该方法，sux很大，但如果绑定字段名为[CONTAINER]，则使用[txtContainer]作为控件的名称仍然是一个好建议。

It looks like the controls on both [Form A] (which appears to be [frmExpense] - It''s actually clearer if the name you use in the explanation matches the name in the code) and [Form B] ([frmExport]) for the field [CONTAINER] are also named [CONTAINER]. Access defaults to that approach, which sux large, but it''s still good advice to use [txtContainer] as a name for controls if the bound field is named [CONTAINER].

这篇关于＃名称？尝试添加新记录时Access表单中的错误的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！