如何将记录从连续子表单复制到另一个连续子表单？ [英] How to copy records from continuous subform to another continuous subform?

问题描述

对于可能提供帮助的人，


我有一个包含2个连续子表单的表单。


-Mainform用于记录产品详细信息。


-first子表单用于记录产品交付日期。


-second子表单用于保存先前子表单的先前交付日期，如果我们修改了第一个子表单中的新日期。


但是，如何复制和放大;将交付日期从第一个子表单粘贴到第二个子表单？


我花了大约2周时间找出解决方案但仍然失败了。非常感谢，如果有人可以提供帮助。

To person who may help,

I have a form with 2 continuous subform.

-Mainform is used to record the product details.

-first subform is use to record the product delivery dates.

-second subform is use to keep the previous delivery dates from first subform if we revised the new dates in first subform.

However, how to copy & paste the delivery dates from the first subform to second subform?

I had spend about 2 weeks time to find out the solution but still failed. Much appreciated if anyone can help on this.

推荐答案

如果两个子表单基于单独的表，那么我将使用INSERT查询来获取其值当前在第一个子表单中选择的记录。

If the two subforms are based on separate tables, then I would use an INSERT query that would get its values from the currently selected record in the first subform.

感谢您的回复;）


是的，它是一个单独的表单。我可以知道如何使用Insert Query吗？此外，是否可以通过按下mainform中的按钮来复制数据？

Thank you for your reply;)

Yes, it is a separate form. May I know how to use the Insert Query? Also, Is it possible to copy the data by pressing a button in mainform?

我知道表单是分开的，但我需要知道表单是否基于不同的表。你能告诉我每个子表单的Record Source属性是什么吗？


是的，你可以通过主表单上的按钮完成所有这些。

I know that the forms are separate, but I need to know if the forms are based on different tables. Can you tell me what the Record Source property is for each subform?

And yes, you can do this all from a button on the main form.

这篇关于如何将记录从连续子表单复制到另一个连续子表单？的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！