By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,466 Members | 1,599 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,466 IT Pros & Developers. It's quick & easy.

Need help accessing different forms

P: 1
Here's what i need to do, keep in mind that I'm new to access and have learned coding is the same as excel.

I have 2 different types of users, those that are users and those that are admin. I have 2 different forms, the user form allows users to see thier data and add to it. the admin people have a different form that allows them to see all records and edit delete and so on.

here's how it flows.

login form takes them to startup form, which just tells them things are loading, then I want that form to direct them to either

frmswitchboarduser for the users or
frmswitchboard for the admin.

I have been looking at all kinds of dlookup code but can't seem to find what i need.. Thanks for any help

Bad Bruce
May 19 '06 #1
Share this Question
Share on Google+
1 Reply


PEB
Expert 100+
P: 1,418
PEB
Here's what i need to do, keep in mind that I'm new to access and have learned coding is the same as excel.

I have 2 different types of users, those that are users and those that are admin. I have 2 different forms, the user form allows users to see thier data and add to it. the admin people have a different form that allows them to see all records and edit delete and so on.

here's how it flows.

login form takes them to startup form, which just tells them things are loading, then I want that form to direct them to either

frmswitchboarduser for the users or
frmswitchboard for the admin.

I have been looking at all kinds of dlookup code but can't seem to find what i need.. Thanks for any help

Bad Bruce

In your form for login in the login bouton you need to create an After Update Event:

I which you have to verify is the user is admin or no

If (he/she is admin) then
DoCmd.OpenForm "AdminSwitchboard", A_NORMAL, , , A_EDIT, A_NORMAL
else
DoCmd.OpenForm "UserSwitchboard", A_NORMAL, , , A_EDIT, A_NORMAL
end if

Have a nice day!

:)
Sep 9 '06 #2

Post your reply

Sign in to post your reply or Sign up for a free account.