User Login, permission level loads different landing forms (1 Viewer)

[Little_Anj]

I found a basic login using macros that works a treat and sets the user id as a tempvars!

(Credit where credit is due http://www.accessallinone.com/31-log-in-form_/)


Each user has a different permission level, and based on that I would like a different form to load.
Managers 1
Admin- Users 2
Maintenance 3
Sales 4

Any ideas how this would work and incorporate it into the working macro?
I made a query to get the permission level ID based on the userID tempvars and it all works! I just don't know how to use it in the macro

Below is the the on event macro for a combo box (from above tutorial)

SetTempVar
Name VARuserID
Expression =[cmbUserName]
close window
object type Form
Object Name UserLogin
Save No

My query to call the permission ID based on Tempvars is called qryUserAndType

My landing pages are named as follows
NavManager
NavAdmin
NavIT
NavRep

My user Name table is called UserName, with the UserTypeID for permission levels

Thanks in advance