Can I make a Searchable Report?

[bcooler]

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.

 

[MajP]

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

http://allenbrowne.com/ser-62.html

 

[bcooler]

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.

 

[sxschech]

Another thought, you can save/print the report to PDF and then the person can do a search through the pdf file.