A Microsoft Office (Excel, Word) forum. OfficeFrustration

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » OfficeFrustration forum » Microsoft Access » Using Forms
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

How to freeze a form?



 
 
Thread Tools Display Modes
  #1  
Old January 15th, 2008, 09:14 AM posted to microsoft.public.access.forms
Ghost
external usenet poster
 
Posts: 181
Default How to freeze a form?

Greeting,
I have a form that contains many txtbox and combo boxes. In this form there
is a commend button to open another form. The problem is, the user can click
on the back form (main form) and it come forward and the other form goes
back. What I want to do is, once the user open the sub form, the user can not
click on the backward form (main form) unless he closes the foreword form.
How can I do that?
thanks
  #2  
Old January 15th, 2008, 10:44 AM posted to microsoft.public.access.forms
Brendan Reynolds
external usenet poster
 
Posts: 1,241
Default How to freeze a form?

"ghost" wrote in message
...
Greeting,
I have a form that contains many txtbox and combo boxes. In this form
there
is a commend button to open another form. The problem is, the user can
click
on the back form (main form) and it come forward and the other form goes
back. What I want to do is, once the user open the sub form, the user can
not
click on the backward form (main form) unless he closes the foreword form.
How can I do that?
thanks



Set the WindowMode argument of the OpenForm method to acDialog as in the
following example ...

Private Sub cmdTest2_Click()
DoCmd.OpenForm "frmTest2", , , , , acDialog
End Sub

--
Brendan Reynolds

 




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump


All times are GMT +1. The time now is 02:17 PM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.