I have created a database in Access for my department and limited the users to only specific tables based on their need and role. However, users have expressed the need to view past work. I do not want to give them access to the table - I am thinking that there should be a way to create a report that shows the data, but how would I set up a search filter option so they can find the one record that they are looking for?
Question Ability to view data? (1 Viewer)
- Thread starter Charmagne
- Start date
Exactly, I do not want anyone to have access to the table. How can they view past records without see the table is the question. Should I build a form or report? Which one allows a user to filter to the specific record they are looking for? I am thinking it will have to be a form - but I am stuck on how they can search for what is needed.
Similar threads
