Security Logon and filtering records

[DeborahP]

I have a database that I have secured by using Access 2003 user security. I need for the database to allow the user to login and once they have logged, to open a form and filter out only their open "tickets" - records.

How can I do this?

Thanks in advance.

 

[stallyon]

you can check who has logged on using the in built CurrentUser() function.

 

[Moniker]

In your form that has the "tickets", I'm assuming you have a UserID of some sort attached to each ticket. On that form, filter by that UserID.

FormName.RecordSource = "SELECT * TicketTableName WHERE UserID='" & LoggedInUserID & "'"

 

[DeborahP]

The currentuser worked great. Can you do this for a security group? I have some VPs who will need to see all tickets and then I have users who only need to see their tickets. The currentuser for individuals worked great.