I am pretty new at this so I will explain what I am trying to achieve
as best as possible.
I need to send info to practices on a weekly basis with patient
information. There are 22 practices and each will receive 2 reports. I
really do not want to create 44 speadsheets every week. What I had in
mind to do was to assign a password to each record based on the
practice. Then creating a user form?? where they select their practice
and enter the password which would then show only their data. Is this
the most sensible way to do this? Is it possible? How can I do the
latter part?