如何创建一个按钮来保存记录，同时还可以做其他事情？ [英] how can i create a button to save records and at the same time to do something else?

问题描述

我有一个包含3个未绑定文本框和一个按钮的表单。我想当我填写所有3个框，我点击按钮在表上设置更新查询，但同时我想重新打开相同的表格。

我知道怎么做查询。但是，点击按钮更新另一个价格后，我怎么能重新打开相同的表格？例如？

我可以使用DoCmd.OpenForm表单名称但我怎么能打开同一个？

任何帮助？

I have a form contains 3 unbound text box and a button. i want when i fill all the 3 of boxes and i click on the button to set an update query on a table but at the same time i want to reopen the same form.
i know how to do the query . but how can i reopen the same form after i click on the button "update another Price" for example?
i can use the DoCmd.OpenForm "Name of the form" but how can i open the same one??
any help?

推荐答案

为什么要在表格已经打开时重新打开？

Why do you want to reopen the form when it''s already open?

我想改变做一个表格以保存文章的折扣价格。

所以我做了一个包含3个未绑定文本框的表格。

我将它转移到组合框中的第一个包含库存中的所有文章＃

第二个是实际价格（售前）。

和第三个是折扣后的价格。

我希望能够循环，这样我就可以节省折扣价，并重新打开相同的表格，为另一篇文章输入另一个折扣价。

well i want to change to do a form to save the discounted prices of the articles .
so i did a form that contain 3 unbound text box.
the 1st on i transfer it to a combo box contain all the articles # in the stock .
the second one is the real price (before sale).
and the third one is the price after discount.
and i want to be able to do a loop so i could save the discounted prices , and reopen the same form to enter another discounted price for another article.

对不起。这是问题的答案吗？我担心它并没有为我解释。也许我只是累了。

I''m sorry. Was that an answer to the question? I''m afraid it didn''t explain it for me. Maybe I''m just tired.

这篇关于如何创建一个按钮来保存记录，同时还可以做其他事情？的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！