Selecting all records if certain value

A

andrew3254

I have a selection form with a pull down menu of courses listed for that
person.

I want to make it so an "Admin" can see all courses but other users only see
those specific to them. How do I do this in a query?
 
K

Ken Snell \(MVP\)

Write a public function that returns the current user's ID (assuming that
this will be same as the PersonID in your table), and name that function
GetCurrentUserID.

Then add a criterion to the field that lists the person's ID:
=GetCurrentUserID() Or GetCurrentUserID() = "Admin"
 
Top