输入相邻的textbox1的特定值后，如何在textbox2中自动添加值? [英] can i add a value in textbox2 automatically when the adjacent textbox1 is entered a specific value?

问题描述

我有一个表pr生成器，它的子窗体具有相同的名称.这两个都分别访问数据frm表的缩进和缩进详细信息.

子表单中有一个文本框item_code.

现在，我要在item_code旁边添加item_description.我也有一个单独的表，用于存储item_code和item_description.因此，如果在pr-generator子窗体中输入了item_code，我希望其相关的item_description显示在相邻的文本框中.

感谢您的帮助.

在此先感谢

I have a table pr-generator which has a subform of the same name. These both access data frm tables indents and indent details respectively.

There is a textbox item_code in the sub form.

Now I want to add item_description next to item_code. Also I have a separate table for storing both item_code and item_description. So if in pr-generator subform the item_code is entered I want its relevant item_description to appear in the textbox adjacent.

Help is appreciated.

Thanks in advance

推荐答案

您需要针对item_code/item_description表编写查询，以检索传递给它的任何item_code的描述.这样的查询称为参数化查询

您可以阅读以下内容:
此处 [ ^ ]
和
此处 [

You need to write a query against your item_code/item_description table to retrieve the description for any item_code that is passed to it. Queries like this are called Parameterized Queries

You can read about them:
here[^]
and
here[^]
and in lots of other places, if you can come up with a suitable search phrase.

这篇关于输入相邻的textbox1的特定值后，如何在textbox2中自动添加值?的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！