Filtering on Loading a form

[Katherine Schomer]

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

[MMcCarthy]

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.