Selecting all records if certain value

[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?

 

[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"