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...
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Need combo box to refresh when moving to new record 2017 1
Form filter problem 3
output filter string to text box on form 3
Search form via filter 5
form dilema! 1
Filtering forms data with a drop down box 4
Macro / replace (wildcards) 1
Macro to copy value in field and insert it into filter 2

Back
Top