Summary VS Details

[Michael's Knight]

I've been able to create Reports to show summaries of data and have it sorted the way I want it, but I also wish to have a detailed report on each individual item in my list, and an easy way to access it. Do I need to create an individual report for each object, or is there a way to create a generic report and have it bring up the details of any given object when selected.
Context: i'm logging specific books and need to be able to sort through them as a list or a detail much like a library catalog. How do I accomplish this?

 

[pbaldy]

One way would be to create a report that shows all items, and open it with this method to restrict it to one:

http://www.baldyweb.com/wherecondition.htm

Another method would be to base the report on a parameter query.

 

[Michael's Knight]

Thank You!
That sounds like what I'm looking to do, now do I have to set up that VBA code for each item, or is there a way to set up a command so the user can type in (or select from a list) a book title, in this instance, and get the detailed report that way?

 

[pbaldy]

Sure, they can enter it in a textbox, choose it from a combo or list box, etc.