FORM Only

[DUNDAPANJ]

let me ask this again, but differently... so no one jumps
my throat for storing confidential information in Access.
there is no real confidential iformation involved here.
this is a class project. and we are allowed to get outside
help on this project.

i got an access database with several tables:
Personnel(ID, Name, DOB, Location...other data)
School(School Name, Classes Taken... other data)
Certificate(Certificate Dates... other data)

AND i got a form that shows these fields. i got this
database password-protected so others dont have access to
the private information such as Place of Birth and Date of
Birth.

What i need to do is to make a form that everyone can
access and this form will only show non-private
information. Now, how would i go about creating something
that only opens the form (one that shows non-private info)
and not the whole databese. and this form will open with a
different password than that which opens that database.
Your help would be greatly appreciated. thank you.

 

[Gina]

My two cents worth, I would use the password the user
signed on with set the visiblity of the fields (and there
labels) on the form. If your passwords have them
belonging to different groups this should work.

Good luck on your CLASS PROJECT!

 

[DUNDAPANJ]

Thank you so very much.

-----Original Message-----
My two cents worth, I would use the password the user
signed on with set the visiblity of the fields (and there
labels) on the form. If your passwords have them
belonging to different groups this should work.

Good luck on your CLASS PROJECT!

.