Startup form selection based on Group permission

  • Thread starter Thread starter BWD
  • Start date Start date
B

BWD

Hello All,

I have an application that I would like to startup with the ID's that
are part of the User group seeing one form and ID's that are
Administrators group seeing a different form.

Any suggestions?

Thanks
 
How do you have your users setup? Are you using an mdw file or do you have a
coustom system?

Either way a general approch would go something like this: (in psudo-code)

1) on the startup menu the startup form should be blank.
2) create a macro named "autoexec". This macro will automaticly fire when
the DB opens. In the macro Give it the RunCode command with a function Main()
3) create a module with any name
4) create a function named "Main()" in the module
5) psudo-code the function:
Function Main()
If <User_Group_logged_in> = Administrator then
DoCmd.OpenForm <Admin_form>
Else
DoCmd.OpenForm <User_form>
End If
End Function
 
Back
Top