Access to personal forms

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a DB that contains personal data for members of a rescue team. This
infomation is everything from personal data to training data. I am
attempting to add UN & PW for each person so that they can view training data
(read only), and be able to change their personal contact information. I
have built the data change form, but I am not sure how to allow members to
only see their specific form and no one else's.......
 
You need to add a field to your table to indicate who owns the record -
store their Access username.

Base your form on a query that uses the CurrentUser() function as a criteria
on this field.

--
Joan Wild
Microsoft Access MVP
"Specific User Form Access" <Specific User Form
(e-mail address removed)> wrote in message
news:D[email protected]...
 
And how i do that?

"Joan Wild" escreveu:
You need to add a field to your table to indicate who owns the record -
store their Access username.

Base your form on a query that uses the CurrentUser() function as a criteria
on this field.

--
Joan Wild
Microsoft Access MVP
"Specific User Form Access" <Specific User Form
(e-mail address removed)> wrote in message
Click to expand...
 
Your Data Change form is based on some table or query. Open the source
table and add a text field called OwnedBy.

Open your Data Change form in design view. View, properties and look at the
Record Source property. Click on the build button (...) and add the OwnedBy
field to the grid and put CurrentUser() as the criteria for it.

When the form opens, only those records where the OwnedBy belongs to the
CurrentUser() will be shown. You'll need to populate the existing records
with their Access username in that field.

You must have some form where this information is entered. If it's entered
by the user, you can add a control for the OwnedBy field to this form and
set its default value to =CurrentUser().
 
Back
Top