automating a filter on a form

  • Thread starter Thread starter Mark
  • Start date Start date
M

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
 
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"
 
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"



.
Click to expand...
 
Back
Top