open specific form after login

[manojsikar1]

Hello....I have set a login form whose command are as followIf Me.qpwd.Value = DLookup("PWD", "AUTHORIZED", "USERID='" & Me.quserid.Value & "'") ThenDoCmd.CloseDoCmd.OpenForm "form1", acNormalElseMsgBox "Invalid Password"end ifI want a help from you all...Say if user logins with "admin", then the form name "form1" opens and if the user logins with "bob" then form name "edit marks" opens....what changes should i do so that user control is there....plz help

[Rainlover]

Perhaps a Table to record User Names, Passwords and the name of the Form you need to open. DLookUp will find the name of the form you need.