How to get the username from workgroup?

[cronid]

I have the security set via the Access workgroups for both groups and users. I want to be able to use the username entered on the logon screen to filter my query results.

How can I get the logon id that was entered when my switchboard form opens?

Thanks in advance.

Dennis Cronin

 

[AccessJunkie]

CurrentUser() will return the logon ID if you are using Access User Level Security.

--
Jeff Conrad
Access Junkie - MVP
http://home.bendbroadband.com/conradsystems/accessjunkie.html
http://www.access.qbuilt.com/html/articles.html

 

[cronid]

thanks very much

 

[AccessJunkie]

You're welcome, glad to help.
Good luck with your project.

--
Jeff Conrad
Access Junkie - MVP
http://home.bendbroadband.com/conradsystems/accessjunkie.html
http://www.access.qbuilt.com/html/articles.html