Automating report choices

P

paulcliman

I have 5 reports almost identical to each other. Each report is based o
a crosstab query (e.g. qrymMaths_crosstab) which in turn is based on
query (e.g. qryMaths) which in turn is based on a main tabl
(tblChildren) joined to a lookup table (e.g. lkpMaths). It is only th
lookup table which changes.
i.e. the reports compare the gender of children with various skill
e.g. mathematical, literary, PSE etc. Each report's design i
identical, save for one word (Maths, Handwriting, etc)

Rather than have a teacher choose each of these from a list on a form
is there any way of maybe presenting him/her with a list box/combo box
which on choice will automatically generate the report?

Or, even, is there a way of automating the production of the queries
select or crosstab?
Thanks in anticipation
Paul C - Liverpool U
 
S

Steve Schapel

Paul,

I think the chances are very high that you only need one Report, and one
set of Queries. If you have a listbox or combobox or option group,
where the teacher can select one of the 5 skill items, then this can be
used:
1a. in the criteria of the queries, using syntax such as
[Forms]![NameOfForm]![NameOfCombobox]
to select the applicable data to be included in the report, or
1b. in the Where clause of the macro or procedure that is used to print
the report, to limit the records included in the report to those
applicable, and
2. in the report itself, in the place where you have the one word
difference... for example you could put an unbound textbox on the report
with its Control Source set to something like
="Sex Comparison on " & [Forms]![FormName]![ComboName] & " skills"
 
G

GaryR

Steve
Your response to Paul helped me, as I have a very similar situation. I would like to use option groups (I have 5 groups on my pop-up form) to limit the report criteria. But...I can't get it to work. (I've had success using combo boxes, but prefer the look and speedy use of option groups. Any advice
--Gary

----- Steve Schapel wrote: ----

Paul

I think the chances are very high that you only need one Report, and one
set of Queries. If you have a listbox or combobox or option group,
where the teacher can select one of the 5 skill items, then this can be
used
1a. in the criteria of the queries, using syntax such a
[Forms]![NameOfForm]![NameOfCombobox
to select the applicable data to be included in the report, o
1b. in the Where clause of the macro or procedure that is used to print
the report, to limit the records included in the report to those
applicable, an
2. in the report itself, in the place where you have the one word
difference... for example you could put an unbound textbox on the report
with its Control Source set to something lik
="Sex Comparison on " & [Forms]![FormName]![ComboName] & " skills
 
Top