我的子表单不是requerying [英] My subform is not requerying

问题描述

如果表单上有多个控件，则表示子表单。当我使用控件选择日期和策略，然后点击一个按钮时，查询'sql调整正确，子表单重新查询很好，一切都很好。


但是...当我选择一个选项组时，查询的sql DOES正确更新，但子表单不重新查询。我不明白为什么。


这是代码

If have a form with several controls on it, and a subform. When I use the control to choose date and strategy, and then hit a button, the query''s sql adjusts properly, and the subform requeries great, and all is well.

BUT... When I select an option group instead, the query''s sql DOES update properly, but the subform does not requery. I can''t figure out why.

Here is the code

展开 | 选择 | Wrap | 行号

推荐答案

我会说选项组代码是简化的，因为没有Select Case来确定选择了哪个选项。我只是想让它在构建Select Case之前重新查询表单。

I will say the option group code is simplified, in that there is not a Select Case to determine which option was selected. I just wanted to get it working to requery the form before building the Select Case.

子表单与表单有什么关系？


是有任何LinkMasteFields& LinkChildFiels设置？


Phil

How is the subform related to the form?

Are there any LinkMasteFields & LinkChildFiels set?

Phil

你已经发布了无法运行的代码。可能是因为你在文字处理器中做了些什么。请发布确切的代码，以便我们不必浪费时间查看实际项目中不存在的问题。


在重新发布之前，您可能需要添加行这有助于您检查您的程序是否实际被触发并运行。 Requery代码在两者中都很好。

You''ve posted code that can''t possibly run. Probably because you''ve done something to it in a word processor. Please post the exact code so that we need not waste time on looking at problems that don''t exist in your actual project.

Before you repost though, you may want to add lines that help you check that your procedures are actually triggered and run. The Requery code looks fine in both.

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