Access 2013错误:#Name? [英] Access 2013 Error: #Name?

问题描述

我创建了一个文本框，将控件源设置为数据库中的一个字段.该表称为tbPriceRange，而这些字段称为PriceRangeOne和PriceRangeTwo

I have created a textbox that has the control source set to a field in the database. The table is called tbPriceRange and the fields are called PriceRangeOne and PriceRangeTwo

在控制源中，我说=[tbPriceRange]![PriceRangeOne] 我的文本框称为PriceOne

In the control source i said =[tbPriceRange]![PriceRangeOne] My textbox is called PriceOne

那么命名错误在哪里?我无法理解，有人可以帮助我吗?

So where is the naming error? I can't get it can someone help me out?

对于表格，我使用tbTagesAngebote作为表格 对于我要使用tbPriceRange的文本框，它是另一张表

For the form i use tbTagesAngebote as table for the Textboxes I want to use tbPriceRange which is a different table

推荐答案

Control source是表单的Record Source属性中字段的名称.
在表单Record Source属性:tbPriceRange"和文本框Control source属性:PriceRangeOne"中输入.

The Control source is a name of a field in the Form's Record Source Property.
Enter in Forms Record Source Property: tbPriceRange, and in TextBox Control source Property: PriceRangeOne.

如果Form还有其他Record Source，则可以将表达式或函数(如DLookup())用作文本框Control source属性.像:=DLookup("PriceRangeOne","tbPriceRange",Criteria). 在这种情况下，TextBox变为只读.

If Form has other Record Source, you can use an expression, or function (like DLookup()) as textbox Control source Property. Like: =DLookup("PriceRangeOne","tbPriceRange",Criteria). In this case, TextBox becomes read only.

这篇关于Access 2013错误:#Name?的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！