>>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
>
>I would suggest to have AutoOpenTables to .F. so you can modify the filters in the Load() and then do OpenTables().

also, you'd probably want to use conditional indexes (faster than filters)