根据Combobox选择将行添加到我的子表单中 [英] Add Row(s) to my subform based on Combobox selection
问题描述
我的Mainform上有一个子表单（数据表视图），用户可以在其中输入信息。我需要有关如何根据我的主窗体下拉框中选择的数字显示子窗体中所需行数的帮助。请参阅随附的GIF。例如，如果用户从下拉列表中选择5，则自动地，下面的子表单应该显示5行用于输入数据，默认值为UNKNOWN。在每一栏中。
非常感谢有人可以帮助我。
Hi,
I have a subform (datasheet view) on my Mainform, where a user can enter information. I need help on how to display the required number of rows in my subform based on the number selected in the dropdown box on my mainform. Please see the attached GIF. for example if a user selects 5 from the dropdown then automatcially the subform below should display 5 rows for entering data, with a default value of "UNKNOWN" in each column.
many thanks if someone can help me here.
推荐答案
我想这个东西可用于它。但是，您需要付出一些努力才能使概念适应您的应用。
问候，
Fish
I guess this stuff could be used for it. However it will require some effort from you to adapt the concept to your application.
Regards,
Fish
Thks Fish。
我不是VBA或访问专家。所以在这里需要你的帮助。
当我从主表单上的组合框中选择一些数字时，我只想在子表单中添加行。默认情况下，我们有1行记录来在子表单中添加数据，但我想根据我的组合框选择显示行。
Thxs再次。
Thks Fish.
I am not an expert on VBA or access. So would need your help here.
I just want to add rows to my subform when I select some number from the combobox on my main form. By default we have 1 row of record to add data to in the subform, but i want to display the rows based on my combobox selection.
Thxs again.
您需要提供更多信息，然后才能获得任何类型的分步帮助。这个问题缺少大部分所需信息。
顺便说一句，为什么这样做是作为一个子表单？您是否知道表单可以包含标题和页脚部分？
You''ll need to provide more information before you can expect any sort of step-by-step help here. This question is missing most of the required info.
As an aside, why is this done as a subform? Are you aware that forms can have header and footer sections?
这篇关于根据Combobox选择将行添加到我的子表单中的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！
