[AccessD] When I open the DB question

There may be easier ways to do this, but I think the following would
work.

First, create a function with code to determine the appropriate form to
open based on records in the table.
Next, create a macro and name it 'AutoExec'.  Within the macro, select
'RunCode' as the Action, and enter the Function name in the appropriate
box at the bottom.

When the mdb file opens, this macro will automatically fire the
function's code to open the correct form.


Mark Boyd 
Senior Consultant 
Enterprise Risk Services 
Deloitte & Touche LLP 
  
Tel: +1 215 405 5576
mboyd at deloitte.com 
www.deloitte.com 


-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Joe Hecht
Sent: Wednesday, December 14, 2005 3:46 PM
To: 'Access Developers discussion and problem solving'
Subject: [AccessD] When I open the DB question

I have a database that if there is no data in a particular
table I want to open one form. If there is data I want to
open a different form.

 

What event am I looking for to do this?

 

Thanks

 

Joe Hecht

jmhecht at earthlink.net

 

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


This message (including any attachments) contains confidential information intended for a specific individual and purpose, and is protected by law.  If you are not the intended recipient, you should delete this message. 


Any disclosure, copying, or distribution of this message, or the taking of any action based on it, is strictly prohibited. [v.E.1]