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 / May 2008

Tip: Looking for answers? Try searching our database.

Open form behavior

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Rickety107 - 02 May 2008 20:09 GMT
I have a form frmLookup that displays all of the programs.  If the user click
the button next to that program it will open a new form frmEvent with all of
the program information.  frmevent is opened using the following code
       stDocName = "frmEvent"
       stLinkCriteria = "[programid] = " & Me.ProgramID
       stOpenArg = ""
       
   DoCmd.OpenForm stDocName, , , stLinkCriteria, , , stOpenArg

frmLookup does not close.

frmEvent has alot of subfrms on it as well. There is code on the form_unload
event of some of these subforms.  I have found out that some users are not
closing frmEvent before they load another program.  With frmEvent still open
and displaying the information about programA they are bringing up the lookup
screen and choosing another program say ProgramB.  Since frmEvent is already
open, when the docmd.openform is called to display the information of
programB, does Access realize the form is already open and just requery the
data for the new program or does it actually close the form and reopen it.

I need to know this to determine if the form_unload events are being called
in this scenario.
Naeem Azizian - 02 May 2008 20:48 GMT
On May 2, 11:09 pm, Rickety107 <Rickety...@discussions.microsoft.com>
wrote:
> I have a form frmLookup that displays all of the programs.  If the user click
> the button next to that program it will open a new form frmEvent with all of
[quoted text clipped - 18 lines]
> I need to know this to determine if the form_unload events are being called
> in this scenario.

It will not close the form, it will just remove the filter and then
filters it again for the new value. It however, "saves" the record,i
you want the events in the unload to happen, by refiltering the form,
it'd be more practical to put those in the afterupdate event of the
form.
 
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.