Startup Form

[paul]

Hi,
In my Access 2000 application (say A.MDB), the Startup
form is a Menu screen. Since I have two differnt groups of
user, so I decide to make two Menu forms.
Based on the user login (another mdb file, say B.MDB),
then it call A.MDB. In my A.MDB file, how to open
different menus instead of Startup form?
Thanks.

 

[Allen Browne]

Create another form, and nominate it as your startup form.

Run your initialization code in its Open event, including opening the
appropriate form for the user. Then cancel the Form_Open so the original one
never shows up.

Alternatively, use a macro named AutoExec with the RunCode action to run
your initialization code and open the desired form.