View Full Version : Open Form upon Login


sboll
12-27-2001, 05:11 AM
I have created a multiuser database that is on a network. There are four groups. Each group has a specific form/interface. When a member of a specific group logs in, I want the corresponding form to open up.
I am new at this so please put it in elementry language! :-)
Thanks
Steve

AlanS
12-28-2001, 01:24 PM
Set up an AutoExec macro. In it, call a function in a standard module. In that function, determine which group the current user belongs to, and based on that open the appropriate form, using DoCmd.OpenForm. In Access help, you can find explanations of AutoExec macros and the OpenForm method.