I need to make a Ms Access database that when a user log's on the computer then opens access they are limited to what they can see and do. I no the code to get windows user name. I would then want the user to only see the information they have been assigned.

Like:
You have a user, and a record the user filled out. another user is assigned to review a user's record. I only want the user that log's on to see is records to review and the reviews done on them.

Hello scoobyhut,

Thanks for the message and question about Microsoft Access. You know, this forum is actually for the Microsoft Access 2010 Programmer's Reference book questions. Would you mind contacting me directly from my website (listed below)?

Thanks,

__________________
Geoffrey L. Griffith
http://www.ImagineThought.com

Wrox Author of:
Microsoft Access 2010 24-Hour Trainer
Access 2010 Programmer's Reference
Access 2007 VBA Programmer's Reference

*** Please click the THANKS button (to the right) if this post helped you! *** ---------------------------------------------------------------------------------------------------------->