Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
Discussion GroupsFormsForms ProgrammingQueriesModules / DAO / VBAReports / PrintingMacrosDatabase DesignSecurityConversionImporting / LinkingSQL Server / ADPMultiuser / NetworkingReplicationSetup / ConfigurationDeveloper ToolkitsActiveX ControlsNew UsersGeneral 1General 2
Access DirectoryToolsTutorialsUser Groups
Related Topics
SQL ServerOther DB ProductsMS OfficeMore Topics ...

MS Access Forum / Forms Programming / August 2005

Tip: Looking for answers? Try searching our database.

Form as a temporary modal

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
oldstonebuddha - 04 Aug 2005 19:11 GMT
I have a comand button on a form to open another form.  When this command
button is used to open the second form, I want it to open as modal.  However,
When I call
DoCmd.OpenForm stDocName, , , , , acDialog, stOpenArgs

It opens modal, and must be closed before switching back to the parent, but
the user can not scroll through the form, (it's a large, complex form with
sub forms).
As I understand it, acDialog sets the modal and popup form properties to
true.  How do I leave the popup = false using the OpenForm method? Or is
there another way to do this?

I just don't wan't users to switch back to the original form without closing
it first.  I've been using the Open args property to link forms, but that
doesn't work if the form being called by the docmd.Openform method is already
open.

Any help would be appreciated.

Scott Collins
Marshall Barton - 05 Aug 2005 00:52 GMT
>I have a comand button on a form to open another form.  When this command
>button is used to open the second form, I want it to open as modal.  However,
[quoted text clipped - 12 lines]
>doesn't work if the form being called by the docmd.Openform method is already
>open.

I don't know what the problem with scrolling could be.  I
would not expect that to be troublesome.

An alternative to using acDialog might be to add a code
character to the front of the OpenArgs string so that the
form can set it's own modal property in its Open or Load
event??

Signature

Marsh
MVP [MS Access]

 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.