子窗体刷新和查询视图。 [英] Subform refresh and query view.

问题描述

再次问好，


我有一个从记录查询中填充的子表单。一旦通过另一个表单添加记录，我需要刷新子表单。我通过在关闭记录添加表单时重新运行子表单的查询来完成此操作。它的作用就像一个冠军，除了我还可以获得查询数据表视图以及子表单。


我相信有一个明显的答案，我错过了。请告诉我您可能需要哪些其他信息来帮助说明问题。


问候，

Willie

Hello again,

I have a subform that gets populated from a records query. I needed the subform to refresh once a record is added via another form. I accomplished this by re-running the query for the subform upon closing the record addition form. It works like a champ, except I also the get the query datasheet view in addtion to the subform.

I am sure there is an obvious answer, that I am missing. Please let me know what other information you may need to help illustrate the problem.

Regards,
Willie

推荐答案

保存查询，将子表单源设置为查询，更改数据集后，调用

Save the query, set the subform source to the query, and after the data set is changed, call

展开 | 选择 | 换行 | 行号

感谢您的回复。


我做到了，但我仍然在刷新子表单的顶部获得查询数据表视图。我想我没有把它放在正确的位置。这是按钮代码。

Thank you for the reply.

I did that, but I still get the query data sheet view on top of the subform being refreshed. I guess I didnt put it in the right spot. Here is the button code.

展开 | 选择 | Wrap | 行号

该行只会执行现在的OnError，放入它如下..

@Rotorian

The line will only execute OnError where it is right now, put it as follows..

@Rotorian

这篇关于子窗体刷新和查询视图。的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！