Reports to a Form?

  • Thread starter Thread starter Carl Johnman
  • Start date Start date
C

Carl Johnman

My manager asked me a interesting question in a meeting
yesterday. The question was: When I select a report from
the database is it possible to click on one of the records
and see in a form all the information regarding that
record, not just what is on the report? Right now I have
to close the report and go back to a query or form and
locate this information. He stated other software programs
do this. I am a novice with access and the question seemed
like a good one and I said I would look into it. We are
currently using access 2002 and have about 6 users. Can
anyone give me some advice on this ?

Thanks very much,
Carl Johnman
 
Carl:

I have never seen the ability to click on information in a report and have
anything happen. Our department is very tied to our Work-In-Process report,
so I built an online version which is actually a form (continuous), not a
report. There is a button beside each record that will open our main
entry/edit form and pull up the appropriate record.

You might try something like that. You can pretty musch make the form look
just like a report if you want, but I chose to make ours look like a form
and allow the users to edit some common fields. The key is to sort it just
like the report.

I also built in some filters and options at the top to change waht displays.
For example, you can click an option button to show only open assignments,
or open and closed.

Hope this helps some. I will keep watching responses to see if anyone has
anything else to say about 'drill down' reports.

Rick
 
I think that ***__possibly__*** Crystal Reports will do this.

Is your manager willing to invest the money for Crystal Reports software and
your time to learn how to use it?
 
Back
Top