Q: Users & Groups with Access 
I am using Microsoft Access 97 and set up an secure database.
Each user log on with his own USERID and I use that USERID to open a
specific screen for the user.

A number of USERS belong to the same GROUP and each GROUP requires the same
screen (Form) to open.

The only way I could write the CODE was as follows:
 If CurrentUser = "Laumed" Then
 GoTo Purchasing
 ElseIf CurrentUser = "DavidRe" Then
 GoTo Purchasing

Laume de Swardt; Laumed@automakers.com


A:
Why not make a table with usernames connected with their group? Then 
set an index to the username. When logging in check which group the 
user belongs to and then make a Select.. Case for starting the right 
form??

Select Case strGroup 
Case "Finance"
 Call frmFinance
Case "Sales"
 Call frmSales
Case Else
 Call frmShop
End Select



Return