Hey guys,
I'm relatively new to programming in Access, and I'm having problems filtering my database so that only certain users can see entries. I'm using the SharePoint Projects Web Database, and want to restrict users from seeing files that are deemed confidential. To solve this, I tried creating a hidden yes/no column and marking the specific entry as being restricted. Then I attempted to write an on load macro that filtered the database for everyone but the specific users, using the CurrentWebUser command, to only see the not confidential entries. However, I can't seem to get it to work. Any help would be greatly appreciated.
If
CurrentWebUser(2) <> "NAM\test"
SetFilter"="WhereCondition">[Forms]![OpenProjects][Restricted]=No