open a form with userlevel criteria

I want to open my database directly to a form and filter that form to only
show info pertaining to the user that is currently logged in.

Now I have a User Database that assings a "rep number" to each person.

My forms already sort the data by the "rep number"

What I want to do is compare the CurrentUser() info to the Debt Advisor table
and find the rep number that matches the current user.

Then filter the current form "greybar" to only show data where the rep number
of the currentuser = the repnumber of the form.

I hope what I am writing is understandable... thanks in advance for any help.


--
Message posted via AccessMonster.com
http://www.accessmonster.com/Uwe/Forums.aspx/access-formscoding/200508/1
.

Loading