表单不更新表 [英] Forms not updating tables

问题描述

在表单控件源中使用此字符串" = DateSerial（year（[StartDate]），month（[StartDate]）+ 6，day（[StartDate]））"。在表单中正常工作，但不更新表中的字段。访问新手 - 任何帮助将不胜感激。在此先感谢。

Using this string in forms control source "=DateSerial(year([StartDate]), month([StartDate])+6, day([StartDate]))". Works correctly in the the form, but does not update the fields in the table. New to Access -- any help would be appreciated. Thanks in advance.

推荐答案

在表单控件源中使用此字符串" = DateSerial（year（[StartDate] ），月（[StartDate]）+ 6，day（[StartDate]））"。在表单中正常工作，但不更新表中的字段。访问新手 - 任何帮助将不胜感激。提前致谢。

Using this string in forms control source "=DateSerial(year([StartDate]), month([StartDate])+6, day([StartDate]))". Works correctly in the the form, but does not update the fields in the table. New to Access -- any help would be appreciated. Thanks in advance.

通过将其放在文本框控件源中，您不会将其存储在任何位置。控制源应设置为字段。将计算设置为默认值，并在表单打开时将字段设置为正确的值。

By putting that in a textboxes control source you are not storing it anywhere. The control source should be set to the field. Put the calculation in the default value and it will set the field to the correct value when the form opens.

感谢您的快速回复 - 我今天早上会尝试，让您知道如何事实证明。

Thanks for the quick reply - I will try that this morning and let you know how it turns out.

Mac，尝试将字符串输入默认值框 - 仍然没有更改/更新表字段。我必须颠倒一个支架或其他东西。我会继续努力。想想任何其他建议，请告诉我。

Mac, Tried entering the string into the default value box -- still no change/update to the table fields. I must have a bracket upside down or something. I''ll keep working with it. Think of any other suggestions please let me know.

这篇关于表单不更新表的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！