如果两个子表单基于单独的表，那么我将使用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.