Hey y'all.

I'm making a database using MS access 2007.

I have a login form from a table which consists of admin and user. I want it admin to enter a different form from the user.

Any ideas?

Your question is vague, do you want the admin to go to one form and users to go to another after they login? If this is the case then use an if statement after login verification to direct users to their form and admins to the admin form.