无法将子窗体中的字段链接到自动填充 [英] Trouble Linking Fields In Subform To Auto Populate
问题描述
我有一个子表单，我正在尝试做的是获得字段价格当我在iteminstall下键入内容时自动填充。
我有一个名为Price List的表，其上的唯一列是iteminstall和price。 。
我能找到关于这个问题的上一篇文章，虽然它适用于那种情况，但它对我不起作用。
在子表单中， " iteminstall"是一个组合框，价格是一个文本框。
任何指针都将非常感激。
I have a subform, and what I''m trying to do is get field "price" to auto populate when I type in something under "iteminstall".
I have a table named "Price List", and the only columns on it are "iteminstall", and "price".
I was able to find a previous post on this issue, and though it worked in that case,it isn''t working for me.
In the subform, "iteminstall" is a combo box, and price is a text box.
Any pointer would be greatly appreciated.
推荐答案
在价格字段中添加跟随控制字段的功能控制价格
In the Price Field add the following function to the Control Field on the control Price
In价格字段将以下函数添加到控件上的控制字段价格
In the Price Field add the following function to the Control Field on the control Price
我复制了并准确地粘贴你写入控制源的内容对于我的子表单上的价格..它没有用，所以我回去仔细检查它是否输入正确，并且价格是控制源。我再次粘贴，但每次我离开设计视图，它都会恢复到价格。另外，我是否必须在引号中加上任何内容？或者他们应该是空的？
I copied and pasted exactly what you wrote into "control source" for ''price'' on my subform.. It did not work, so I went back to double check that it was typed right, and "price" was in control source. I pasted again, but everytime I leave design view, it reverts back to price. Also, do I have to put anything in the quotation marks? Or are they supposed to be empty?
我是否可以通过电子邮件将数据库发送给您查看，或者将其上传到某处。我没有什么可隐瞒的，我只想修复它。
Would it be possible for me to email you the database for you to look at, or upload it somewhere. I have nothing to hide, I just want to get it fixed.
这篇关于无法将子窗体中的字段链接到自动填充的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！
