Hi
Yes
Actual vba code depends on if you are talking about the Users Network Login id, or their Access (security) log in
For Access login id you can use CurrentUser() - but this is only practical if you have implemented Access Security, or at least the log in portion of it, otherwise it will always return "Admin"
If you want Netork login id see
Basically what you need to do is to set your start up options to run some code
the outline of what you need in that code is
If CurrentUser() = "A UserId" Then
' open form 1
Else
' open form 2
end If
in practice if you have several users and / or to make it so that adition of new users or removal of old users does not require changes to the code, you may wish to consider havinga table which lists the users and tells you which start up form is applicable to them. Then look up the user in the table and open the appropriate form
Regards
Ken Reay
Freelance Solutions Developer
Boldon Information Systems Ltd
Website needs upgrading, but for now -
UK