Limiting data access based on who logs in

Ok, I have 40 different users. Each user manages a subset of the total database. Currently I have a pull-down menu to let the user select their subset and then manage the data within it. I'd like to use their login info to pre-select the subset so that they have access only to their assigned areas. How do I "send" the subset name from one asp page to another?

the db is "2004" the table is "Students"

As a rank amateur, specificity is appreciated

I've always assigned a session variable along with the user (actually it was part of the user's logged in info) Like this on a successful login:

Session("userLoggedIn") = "Chuck"
Session("areaAccessTo") = "02,33,42"

Then, each page, depending on the kind of data it deals with (ie, section 02), would use InStr to check if it finds that string in their areaAccessTo variable. If not; they dont have access.

Ok, lets say I have one database with fields named Club, Name, e-mail, phone.

Based on a log in I want to limit access to the information for the club they are a member of.

Will your suggestion work in this case ?