Simple Password Form

[Chuckles]

I am building a simple access database for a small home business. I
have a table containing userid, password, and rights(either admin or
regular) which will simply stop someone from clicking on certain
command buttons. Setting up users and groups is really not neccessary
as it is just a few people logging in. The problem i have Is I can't
figure out how to return the rights value after the usrid and password
check ok. I can get it to log in just not return the value in the
rights column

[Mark]

Could you not use a Dlookup function?

Something like dlookup("Rights_Field","Rights_Table","Rights_User ID =
forms!Form_Name_Where_ID_Is_Entered!Textbox_Name")

Allen's site will give you an insight into Dlookup
http://allenbrowne.com/casu-07.html

Mark

"Chuckles" <tm*****@new.rr.com> wrote in message
news:11**********************@f14g2000cwb.googlegr oups.com...

I am building a simple access database for a small home business. I
have a table containing userid, password, and rights(either admin or
regular) which will simply stop someone from clicking on certain
command buttons. Setting up users and groups is really not neccessary
as it is just a few people logging in. The problem i have Is I can't
figure out how to return the rights value after the usrid and password
check ok. I can get it to log in just not return the value in the
rights column

[Chuckles]

Thanks Mark
That worked.
Great link also