469,647 Members | 1,794 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,647 developers. It's quick & easy.

Need help accessing different forms

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
1 1317
PEB
1,418 Expert 1GB
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.

Similar topics

3 posts views Thread by Martien van Wanrooij | last post: by
6 posts views Thread by Chris Styles | last post: by
3 posts views Thread by judy.j.miller | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.