如何同步打开表单 [英] How to Open a Form Synchronously
问题描述
希望这是问题的窗口。
我的问题:
我有两种形式(比如FORM_1和Form_2)
如您所知(更多人),在Excel中,我可以使用代码(在FORM_1中)从FORM_1打开FORM_2:
FORM_2.Show()
如果我使用vbModal模式(FORM_2.Show(vbModal),FORM_1代码中的下一行将不会执行,直到FORM_2关闭。
问题是:我可以获得相同的Access VBA中的效果?我希望避免在关闭FORM_2之前继续在FORM_1中执行代码。
我使用2007版的MS Office。
提前谢谢!
Hope this is the window for question.
My question:
I have two forms (say FORM_1 and Form_2)
As you know (more of you), in Excel, I can open FORM_2 from FORM_1 using code (in FORM_1):
FORM_2.Show()
If I use vbModal mode (FORM_2.Show(vbModal) the next line in FORM_1 code will not be executed until FORM_2 is closed.
The question is: Can I obtain the same effect in Access VBA ? I wish to avoid to continue code execution in FORM_1 before I close FORM_2.
I use 2007 version of MS Office.
Thank you in advance !
推荐答案
Access中的表单也有一个属性 .Modal ,允许他们完全控制。
Forms in Access also have a property .Modal which allows them to take full control.
感谢您的回复,NeoPa。
与Excel VBA不同,Access中的.Modal仅停止表单失去焦点。
>
Thank you for your reply, NeoPa.
Unlike in Excel VBA, the .Modal in Access only stop the form to lost focus.
我找到了解决方案:
I find the "solution":
这篇关于如何同步打开表单的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!