Limited Access and Queries not functioning

[mberding]

I have a DB that's pretty simple, really. Standard User can see and modify only the records they created. Supervisors should be able to edit a subgroup of users' records, all said subrecords have the Supervisor's login name already in a text field in the record.

The Standard User is doing fine. The Supervisor can view and edit the correct records. BUT - the supervisor can only get to those records by manually browsing and clicking through records to find the correct one. When the supervisor does a "Find" on any field, they get "No Records match this request." Obviously this is a false error message, the records exist.

So why can't my Supervisor's search for records?

The basic code for viewing records at the Supervisor level is:

Get ( AccountName ) = Created_By or Get ( AccountName ) = Supervisor_Name

Help!