Apply Filter

[alanquick]

OK Luddite is back again, now with the following issue.........

Database access is configured to an individual's SAPID and logon is managed through Environ("USERNAME") linked to the SAPID.

I have now created a Form for assigning actions to individuals, but I want the individual user to only see their actions and not everyone else's, so in essence I want to apply a filter where the SAPID = Environ("USERNAME") at least I think thats what i want to do

Any suggestions as I've tried multiple options but it doesn't work. The DoCmd.applyfilter works fine if i specify an individual SAPID, but i need this to happen automatically

Not sure that makes sense but looking forward to any suggestions

 

[isladogs]

Database access is configured to an individual's SAPID and logon is managed through Environ("USERNAME") linked to the SAPID.

I have now created a Form for assigning actions to individuals, but I want the individual user to only see their actions and not everyone else's, so in essence I want to apply a filter where the SAPID = Environ("USERNAME") at least I think thats what i want to do

I remember the phrase SAPID from a previous thread of yours ....
Can you please either explain the section I've highlighted in RED or provide a link to the earlier thread if it was explained before

 

[Gasman]

The way I have implemented a similar task, is to store the userid in a Tempvar, then filter on that Tempvar.
In my case it was for Managers and their team members, so they only saw their own team members.