将表单数据传输到新表单 [英] Transfering Data of a form to a new form
问题描述
大家好，任何人都可以教我如何做这个场景
将表格数据转移到新表格
情景是：
我有一个交货收据表（硬件），其中包含以下字段
- id - 格式化为DR-00000
- 公司
- 地址
- 指定
- 产品
- 产品系列
- 等等
它有一个子表格
- 数量
- 描述
- 序列号
手动输入此表格以获取数据。
然后我有另一张BLANK表格，即拉出表格（硬件）和我的DR表格相同的字段除了ID
我的ID格式为POR - 00000
我想要的是我的拉出表单我有一个按钮（命令按钮）然后每次我点击该按钮它显示另一个表格，其中包含我的DR号码列表，它可以是一个列表框甚至是一个组合框t o查看我的DR ID列表，然后如果选择某个DR ID，那么该交货收据ID的相应数据将在我的空白拉出表单中生成，以便它将自动显示在我的拉出表格中，无需手动输入，谢谢一个很大的帮助
hi guys can anybody can teach me how to do this scenario
Transfering Data of a form to a new form
The Scenario is:
I have a Delivery Receipt Form (Hardware) with a fields of the following
- id - Formatted as "DR-00000"
- company
- address
- designation
- product
- product line
- etc
It Has a subform of
- qty
- description
- serial
This form is manually inputted to get the data.
Then i have another BLANK form which will be the Pull out Form (Hardware) and have same field as my DR form except for the ID
my ID formatted as "POR - 00000"
I want is in my Pullout Form i have a button (command button) then everytime i click that button it show another form that has the list of my DR number it can be a listbox or even a combo box to see the list of my DR ID and then if choose a certain DR ID the corresponding data for that Delivery Receipt ID will generate in my blank Pull Out Form so that it will automatically show in my Pull Out Form no need for manual entry, thanks for a big help
推荐答案
我不确定你的描述究竟是什么，但是。
您可以使用带有组合框（cboDRID）和命令按钮（cmdOpenForm）的表单（frmSearch）打开另一个表单（frmHardware）。
假设：硬件是名称表格或查询。
设置frmHardware的记录源以返回所有记录，即硬件表或适当的查询。
设置组合框的属性如下：
列数= 1
行源类型="表/查询"
行源=" SELECT id FROM硬件ORDER BY id ASC"
绑定列= 1
放下foll命令按钮后面的代码...
I''m not sure from your description exactly what you are looking for but.
You can have a form (frmSearch) with a combobox (cboDRID) and a command button (cmdOpenForm) to open the other form (frmHardware).
Assumptions: Hardware is the name of the table or query.
Set the Record Source of frmHardware to return all records i.e. the Hardware table or appropriate query.
Set the properties of the combobox as follows:
Column Count = 1
Row Source Type = "Table/Query"
Row Source = "SELECT id FROM Hardware ORDER BY id ASC"
Bound Column = 1
Put the following code behind the command button...
简单说明
Form1（With数据） - DRF 00000 - ID
Form2（无数据） - POR 00000 - ID
Form3（DRF 00000 ID清单 -
$来自Form2的b $ b（无数据）我有一个按钮，如果我点击那个按钮我将转到form3这是ID（DRF-00000）的列表然后从form3我可以使用combox选择一个ID如果我选择id例如DRF-00001然后我点击生成我将再次转到Form2
来自Form1（带数据）的DRF 00001的值必须转移到Form2（无数据）
我理解它的难度让我难以解释：）抱歉
For simple explanation
Form1(With Data) - DRF 00000 - ID
Form2 (No Data) - POR 00000 - ID
Form3 (List of DRF 00000 ID-
from Form2(No Data) i have a button if i click that button i will go to form3 which is the list of ID (DRF-00000) then from form3 i can pick a certain ID using combox if i choose for id for example DRF-00001 then i click generate i will go now to Form2 again
The Value of DRF 00001 from Form1(with Data) must transfer to Form2(No data)
am i making sense its rili hard for me to explain : ) sorry
好的，您必须停止将数据视为存储在表单中。它们只是允许您查看记录的界面。
如果您解释为什么您正在做您正在做的事情，我可以进一步提供帮助。
Mary
Ok you have to stop thinking of the data as being stored in the forms. They are only interfaces to allow you to view the records.
If you explain why you are doing what you are doing I may be able to help further.
Mary
这篇关于将表单数据传输到新表单的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！
