[AccessD] Open form

Jim Lawrence accessd at shaw.ca
Fri Aug 15 21:37:11 CDT 2008


As chance may be I have been working on a similar issue with a late night
project.

When the form is select the program first checks if it is loaded, if it is
not loaded, loads it or sets focus to the form and turn it visible.

'Code from the caller form...
If IsLoaded("frmEnterDate") = True Then
   [Forms]![frmEnterDate].Visible = True
   [Forms]![frmEnterDate].SetFocus
        
Else
   DoCmd.OpenForm "frmEnterDate"
    
End If
'............................

Jim

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Jennifer Gross
Sent: Friday, August 15, 2008 2:37 PM
To: AccessD List
Subject: [AccessD] Open form

Happy Friday!

I want to open form1, wait until the user finishes with form1 and closes it,
then open form2.  Because form1 gets opened from other places in the program
I don't want to put the trigger in the form1 close event.  If possible, I
want to keep the logic tidy where it is pertinent in the original calling
code.  I seem to remember doing this before, but can't find how it is done.

Any help is greatly appreciated.

Jennifer


-- 
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com




More information about the AccessD mailing list