By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
435,543 Members | 2,085 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 435,543 IT Pros & Developers. It's quick & easy.

Filtering on Loading a form

P: 1
I have 5 people entering data in Access 2007 form, and I don't necessarily want them to be able to view each other's data entries. When they enter the data, I have forms set to data entry. But I need to give them a way to edit their records if needed. So I created a separate data entry form that is not set to data entry. Is there a way that I can have them filter for their records upon opening this form? I am thinking when they clicked to open the editing form they would be prompted with a window that asks them to choose what records (list of users names) they want to view. Then the form would only open their records.

Any help on this would be great.

-k
Jun 13 '07 #1
Share this Question
Share on Google+
1 Reply


MMcCarthy
Expert Mod 10K+
P: 14,534
I have 5 people entering data in Access 2007 form, and I don't necessarily want them to be able to view each other's data entries. When they enter the data, I have forms set to data entry. But I need to give them a way to edit their records if needed. So I created a separate data entry form that is not set to data entry. Is there a way that I can have them filter for their records upon opening this form? I am thinking when they clicked to open the editing form they would be prompted with a window that asks them to choose what records (list of users names) they want to view. Then the form would only open their records.

Any help on this would be great.

-k
Normally you would restrict their access by stamping all records they enter with a user identity. By this I mean a record would have a column which would record the user. The user can be identified on entry to the database. Check out the following tutorial

Function to return Username of current user

The username can then be stored in a Public variable (see Variable Scope in VBA for MS Access). Then you simply restrict the returned records to those of the current user.
Jun 15 '07 #2

Post your reply

Sign in to post your reply or Sign up for a free account.