Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Can I make a Searchable Report?

Status
Not open for further replies.

bcooler

Programmer
Joined
Jun 13, 2009
Messages
132
I have users enter a lot of data across 3 forms. One user in particular wants to review all the data from one report AND be able to search on it so he can get a feeling about what's going on with the item in question.

My concern is that I don't really want this user to be able to change table info without the protection of forms, so I thought a report would be the appropriate solution. However, I don't think a report is searchable (at least my prevously created ones aren't).

Is the only solution here to create a form with all fields locked so he can look at the data without changing it? This seems a little clumsy, but I think it would work.
 
Making searchable forms that are read only is pretty standard. You can lock the data at the form level, no need to lock controls. Something like this may help
 
Thank you. I ultimately created a "every field in the query" form so I could search on anything, but used your suggestion about the form level lock.
 
Another thought, you can save/print the report to PDF and then the person can do a search through the pdf file.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top