Dlookup字段不保存 [英] Dlookup Field Not Saving

问题描述

我有一个带有查找字段的Acess数据库，查找在表单上正常工作，它访问另一个名为原始资料的表格来获取信息。


= DLookUp（" [£Per Kg]"，" [Raw Materials]"，[[ID] = [material（main）]"）


Dlookup字段未保存到链接到表单的输入表。


我做错了什么？

I have an Acess database with a lookup field, the lookup is working correctly on the form, it accesses another table called raw materials for the information.

=DLookUp("[￡ Per Kg]","[Raw Materials]","[ID]=[material (main)]")

The Dlookup field is not saving to the Input table which is linked to the form.

What am I doing wrong?

推荐答案

我有一个带有查找字段的Acess数据库，查找在表单上正常工作，它访问另一个名为原始资料的表格来获取信息。


= DLookUp（" [£Per Kg]"，[Raw Materials]，[ID] = [material（main）]"）


Dlookup字段没有保存到链接到表单的Input表。


我做错了什么？

I have an Acess database with a lookup field, the lookup is working correctly on the form, it accesses another table called raw materials for the information.

=DLookUp("[￡ Per Kg]","[Raw Materials]","[ID]=[material (main)]")

The Dlookup field is not saving to the Input table which is linked to the form.

What am I doing wrong?

嗨


需要摩尔信息。


你在哪里/怎么样？ using = DLookUp（" [£Per Kg]"，[[Raw Materials]"，[[ID] = [material（main）]"）


表单是否绑定到哪个表格。

你在哪里/如何保存查找值

等


MTB

Hi

Moore information required.

Where/how are you using =DLookUp("[￡ Per Kg]","[Raw Materials]","[ID]=[material (main)]")

Is the form bound, if so, to what table.
Where/how are you trying to save the lookup value
etc.

MTB

我将dlookup命令放在一个名为数据输入表单<的表单上的字段 Main Mat£Per Kg 的控制源中/ i>。


我认为表单绑定到输入表，但Dlookup字段试图从 Raw中提取价格材料表。


它将数据输入表单中的 Material Main 字段值与进行比较原材料表上的每千克字段。


Dlookup在输入表单上工作正常，但是当它被保存时，Dlookup查询找到的值没有保存到输入表，字段只是空白。是否必须以某种方式连接？。

I am putting the dlookup command in the control source of field Main Mat ￡ Per Kg on a form called data input form.

I think the form is bound to the input table, but the Dlookup field is trying to pull the price from the Raw Materials table.

It compares the Material Main field value in the data input form to the ￡ Per Kg field on the Raw Materials table.

The Dlookup works fine on the input form, but when it is saved the value that the Dlookup query has found is not saving to the Input Table, the field is just blank. Does it have to be connected in some way?.

我将dlookup命令放在字段 Main的控制源中在一个名为数据输入表格的表格上的Mat£Per Kg 。


我认为表单绑定到输入表，但Dlookup字段试图从原材料表中提取价格。


比较 Material Main 数据输入中的字段值形式为原材料表上的£Per Kg字段。


Dlookup在输入表单上工作正常，但是当它被保存时，Dlookup查询找到的值没有保存到输入表，字段只是空白。是否必须以某种方式连接？

I am putting the dlookup command in the control source of field Main Mat ￡ Per Kg on a form called data input form.

I think the form is bound to the input table, but the Dlookup field is trying to pull the price from the Raw Materials table.

It compares the Material Main field value in the data input form to the ￡ Per Kg field on the Raw Materials table.

The Dlookup works fine on the input form, but when it is saved the value that the Dlookup query has found is not saving to the Input Table, the field is just blank. Does it have to be connected in some way?.

再次嗨


如果您要输入新记录，请尝试将此

= DLookUp（" [£Per Kg]"，[Raw Materials]，[ID] = [material（main）]"）

在DEFAULT值中[Main Mat£Per Kg]控件（不是控制源），并将控制源设置为要保存的字段，即。将它绑定到[Main Mat£Per Kg]。假设表格绑定到这个表格！


看看是否这样做。


MTB

Hi again

If you are entering a new record, then try putting this
=DLookUp("[￡ Per Kg]","[Raw Materials]","[ID]=[material (main)]")
in the DEFAULT value of the [Main Mat ￡ Per Kg] control (not the Control Source), and set the Control Source as the field you want to save it in, ie. bind it to [Main Mat ￡ Per Kg]. Assuming the form is bound to this table!

See if that does it.


MTB

这篇关于Dlookup字段不保存的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！