Having a Report to open in a form

  • Thread starter Thread starter newsgroups_44
  • Start date Start date
N

newsgroups_44

Sorry if this has been asked, but to try word a search to find what i
want...:)

I have a form. This form has records. Most records will have a
corresponding report. I would like to either:

1. Hyperlink each record so it will open the report but within the
form, so I could add a close button or...
2. Have the report just simply be part of each record on the form.

Thank you in advance for your help,
Stephen Craig
 
Sorry if this has been asked, but to try word a search to find what i
want...:)

I have a form. This form has records.
Click to expand...

Sorry, but no: it doesn't.

The Form is JUST A WINDOW. It *displays* records which are stored in a
Table. The records exist in the table, and ONLY in the table.
Most records will have a
corresponding report. I would like to either:

1. Hyperlink each record so it will open the report but within the
form, so I could add a close button or...
2. Have the report just simply be part of each record on the form.
Click to expand...

Could you explain what you mean by "have a corresponding report"? Do
you have multiple Access Reports, each displaying different data? In
what way are these reports different, and in what way are they
similar?

You can certainly use VBA code to launch a chosen Report (or, more
frequently, to launch a common Report filtered to display a different
subset of data) but I'm not sure I understand the scenario!

John W. Vinson[MVP]
 
Okay get all technical on me. :)

I have (or will have) about 255 reports each detailing a specific
program/term/course/fees for a given academic term. There will be so
many reports as to provide the best and most accurate info. For staff,
I wanted to create just a quick and dirty form that they could look up
a program, click on it and see the specific report, but have that
report open in the form.

Yes, right now, i have just hyperlinked all the academic terms, so you
click on one in the form, and it opens the report. I just thought it
might be easier to use if the report opened within the form. Does this
make more sense?

Thank you so much:
Stephen Craig
 
Okay get all technical on me. :)

I have (or will have) about 255 reports each detailing a specific
program/term/course/fees for a given academic term. There will be so
many reports as to provide the best and most accurate info. For staff,
I wanted to create just a quick and dirty form that they could look up
a program, click on it and see the specific report, but have that
report open in the form.

Yes, right now, i have just hyperlinked all the academic terms, so you
click on one in the form, and it opens the report. I just thought it
might be easier to use if the report opened within the form. Does this
make more sense?
Click to expand...

Not to me!

Again: how do these reports differ IN STRUCTURE?

Do they all look alike, but just display different subsets of the
data?

If so, you may do much better to use *one single* Report, based on
*one single* Query, with parameters to select the data appropriate for
a specific program/term/course/fees.

Maintaining 255 different Access reports is a minefield for typos and
boredom-generated errors. Can you instead let the computer do the
boring repetitive work, by using Parameter Queries and variable
reports? What is the structure of the Tables upon which the reports
are based?


John W. Vinson[MVP]
 
Back
Top