I have a form which displays all names in my table. When an individual logs onto my system with only *individual* rights, I want him to see only his data. How do I go about setting this filter, when they log in I have the record number stored to a public variable. Now when they enter ANY form it verifies the access level. I need to be able to read the contents of my variable that stores their record number and display only that record. I keep going to the top of my table, and I don't want that. The data environment is tied to each form so I am dealing with the cursor. Any help would be appreciated
Thx
Jon Paskett
Microsoft Certified Systems Engineer
We all have to start somewhere...
Sometimes over again!