根据主窗体日期范围控件填充子窗体日期控件 [英] Populate a subform date control based on main form date range controls

问题描述

您好！


在我的主表单上，我有两个日期控件，dtmTrainingStartDate和dtmTrainingEndDate。在子表单上，我有一个日期控件dtmWeekEndingDate。我想要做的是自动填充子表单控件与主窗体日期范围控件之间的所有星期六日期。


如果可以的话，你会怎么做呢？


谢谢!!!

戴夫

Hello!

On my main form I have two date controls, dtmTrainingStartDate and dtmTrainingEndDate. On a sub form, I have a date control dtmWeekEndingDate. What I would like to do is auto-populate the sub form control with all the Saturday dates between the main form date range controls.

If this is possible, how would you go about doing it?

Thanks!!!
Dave

推荐答案

每个日期应该有1条记录吗？


或者你想要一个像组合框一样的控件，其中组合框列出了可用的日期？


是用于选择还是数据输入的子表单？

Should there be 1 record for each date?

Or do you want a control like a combobox, where the combobox lists the available dates?

Is the subform meant for selection or for data entry?

每个日期的一条记录。子表格将用于每周付款。这样，自动填充应该防止丢失。如果用户必须手动键入所有日期，则为日期。

One record for each date. The sub form is going to be for making payments every week. This way, auto-populating should prevent "missing" dates if the user has to manually type in all the dates.

有关如何执行此操作的建议或是否可能？

Any suggestions on how to do this or is it not possible?

这篇关于根据主窗体日期范围控件填充子窗体日期控件的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！