click item, see more info

[Catherine Jo Morgan]

How do you set up a form or report so that it's possible to click on a field
and see more details? This is a feature in most accounting programs, for
example. In a profit and loss report, you can click on a category total and
get a list of the relevant transactions in that category, for that time
period.

If you can tell me what this is called, or the basic steps involved, maybe I
can get the step by step instructions from a book. Right now I just need a
lead. TIA

[Bob Quintal]

"Catherine Jo Morgan" <cj******@hemc.net> wrote in
news:ku********************@hemc.net:

How do you set up a form or report so that it's possible to click on a
field and see more details? This is a feature in most accounting
programs, for example. In a profit and loss report, you can click on a
category total and get a list of the relevant transactions in that
category, for that time period.

If you can tell me what this is called, or the basic steps involved,
maybe I can get the step by step instructions from a book. Right now I
just need a lead. TIA

The principle is "Drilling Down" and you create a new form to show the
details fields, then set up an On Click event in the parent field (or a
separate "show details" button beside the field that calls the new form
with the where clause set to filter only for the current value of the
parent record.

e.g. Docmd.openform "new form",acNormal,,"[keyfield] = """ & me.keyfield
& """",acFormReadOnly

Bob Q.

[Larry Linson]

"Catherine Jo Morgan" wrote

How do you set up a form or report
so that it's possible to click on a field
and see more details? This is a feature
in most accounting programs, for
example. In a profit and loss report,
you can click on a category total and
get a list of the relevant transactions in
that category, for that time period.

You can do this in a Form, but not in a Report... Reports are not intended
to be interactive; Forms are. Bob gave you some basics, but I'd recommend
using the DoubleClick event... in some cases, you may want to Click into a
Control to change the value.

You'll find an example of doing this in the sample image-handling databases
that you can download from http://accdevel.tripod.com... in that case,
double-clicking on any field in the continuous view will open the detail
form (the method is the same for drill-down).

Larry Linson
Microsoft Access MVP