open specific form after login

[manojsikar1]

Hello....

I have set a login form whose command are as follow

If Me.qpwd.Value = DLookup("PWD", "AUTHORIZED", "USERID='" & Me.quserid.Value & "'") Then
DoCmd.Close
DoCmd.OpenForm "form1", acNormal
Else
MsgBox "Invalid Password"
end if


I 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

 

[dstone10]

I would just make the login form invisible instead of closing it. Works for my application.

This post may help:

http://www.access-programmers.co.uk/forums/showthread.php?t=235323&highlight=login+form

 

[manojsikar1]

do you have any sample db...if possible plz send the attachment...

 

[pr2-eugin]

Here is a small sample I put up.. use the Login Paul and password = "pwd123".. Hope this helps..