Can I set up a password procedure from a cmd button on a form?

[GarryD]

I want to use security from a command button instead across the whole
database. I use access 97, and want to limit the users of a report. Any
suggestions please

 

[Joan Wild]

I want to use security from a command button instead across the whole
database. I use access 97, and want to limit the users of a report.

You can password protect a single form or report
See these knowledge base articles:
http://support.microsoft.com/?id=209871
http://support.microsoft.com/?id=179371

 

[simon]

You can password protect a single form or report
See these knowledge base articles:
http://support.microsoft.com/?id=209871
http://support.microsoft.com/?id=179371

HI Joan
I have the other question for these knowledge base articles:
These articles work very good.
But would like to add more password for more user to open the same form. I
try to remove the primary key in order to add more user for the same form. It
only work with the first password was enter in the password table.
I can't apply it to my subform link with customerID when call it from the
mainform with a command button. it only work if i open this subform from
database window which no link or filter from mainform.
Any work around these two problem. Thanks
simon