automating a filter on a form

[Mark]

I have written a data base to keep our data about 3 work
shifts. I want to automate the employee form so that only
the second shift sup will see his people and so on.
Thanks for any help

 

[Jim McDonald]

Hi Mark..
If you make the users sign on via MDW (see security help) you can look up
`who is signed in with currentuser. Then simply filter the records on
"Sup=" & chr(13) & currentuser & chr(13) where the sup field in the record
is set to whatever they sign in as (eg "Sup1"

 

[Mark]

Thank you I will try that.

-----Original Message-----
Hi Mark..
If you make the users sign on via MDW (see security help) you can look up
`who is signed in with currentuser. Then simply filter the records on
"Sup=" & chr(13) & currentuser & chr(13) where the sup field in the record
is set to whatever they sign in as (eg "Sup1"



.