Full Version: Multiple forms to one table
UtterAccess Discussion Forums > Microsoft® Access > Access Forms
geee112
I am trying to create a from for each of my co-workers which will input data into one table. The forms are the same layout. I want the forms to be unique, meaning each person only views there own information. Is this possible, and if so how can I do it?
MattJ
Welcome to UA!
You should only have a single form that is used for all users, and restrict the information displayed based on the current user.


HTH
Matt
dashiellx2000
Hello and Welcome to UA!!!

If the form's all have the exact same layout but you want them to only able to view their own data, you will need to assocaite each record in the database with the person. One of the easiest ways would be to add a field which will hold a user id or something that is unique to each user. You can use an API to Get Login name of the user on the network or create your own login procedure like this one from the code archive.

HTH.
This is a "lo-fi" version of our main content. To view the full version with more information, formatting and images, please click here.