[AccessD] When I open the DB question

Joe,

Do you mean you want to open different forms when you open your database?

Why not use Autoexec macro? Something simple as this (macro converted to
VBA):

    If (DCount("*", "Table1") > 0) Then
        DoCmd.OpenForm "frmOne", acNormal, "", "", , acNormal
    End If
    If (DCount("*", "Table1") = 0) Then
        DoCmd.OpenForm "frmTwo", acNormal, "", "", , acNormal
    End If

Shamil

----- Original Message ----- 
From: "Joe Hecht" <jmhecht at earthlink.net>
To: "'Access Developers discussion and problem solving'"
<accessd at databaseadvisors.com>
Sent: Wednesday, December 14, 2005 11:46 PM
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