Display query parameters on report

I have created a QBF to start a 'make table query'. This data in the make
table query is then put through a 'cross tab query' and finally into a
calander type report. i am wanting to show on the report the query
parameters selected at the QBF stage. I thought I should be able to use the
control source function/expression builder but cant seem to work it out.

Any help would be great, cheers

Reading through other logs noted that the form needs to be kept open for the
parameter to be displayed, is this a hard and fast rule?? will do if so but
if their are other suggestons bring them on!!

=([Forms]![F_PrintEEReports]![getWkMoDate])


"Little pete" wrote:

I have created a QBF to start a 'make table query'. This data in the make
table query is then put through a 'cross tab query' and finally into a
calander type report. i am wanting to show on the report the query
parameters selected at the QBF stage. I thought I should be able to use the
control source function/expression builder but cant seem to work it out.

Any help would be great, cheers

Little pete wrote:

Reading through other logs noted that the form needs to be kept open for the
parameter to be displayed, is this a hard and fast rule?? will do if so but
if their are other suggestons bring them on!!

=([Forms]![F_PrintEEReports]![getWkMoDate])

Yes, this is a hard and fast "rule". Actually, it's just
logical that if the form is not open, any values it may have
displayed can't possible available through the form. Don't
forget that the Forms collection only contains open forms.

Either leave it alone or, instead of closing it, make it
invisible and close it in the report's close event
procedure.

--
Marsh
MVP [MS Access]

Cheers Marsh

Can you shead some light on this make it invisible and close it in the
report's close vent procedure.

thanks

"Marshall Barton" wrote:

Little pete wrote:

Reading through other logs noted that the form needs to be kept open for the
parameter to be displayed, is this a hard and fast rule?? will do if so but
if their are other suggestons bring them on!!

=([Forms]![F_PrintEEReports]![getWkMoDate])

Yes, this is a hard and fast "rule". Actually, it's just
logical that if the form is not open, any values it may have
displayed can't possible available through the form. Don't
forget that the Forms collection only contains open forms.

Either leave it alone or, instead of closing it, make it
invisible and close it in the report's close event
procedure.

--
Marsh
MVP [MS Access]

Little pete wrote:
Can you shead some light on this make it invisible and close it in the
report's close vent procedure.

Simply replace the existing DoCmd.Close with:
Forms![theform].Visible = False
(which can be shortened to:
Me.Visible = False
if the line is in the form's module) and put:
DoCmd.Close "theform", acForm, acSaveNo
in the report's Close event procedure.

Be sure to change theform with whatever you named your qbf
form.
--
Marsh
MVP [MS Access]



Little pete wrote:
Reading through other logs noted that the form needs to be kept open for the
parameter to be displayed, is this a hard and fast rule?? will do if so but
if their are other suggestons bring them on!!

=([Forms]![F_PrintEEReports]![getWkMoDate])

"Marshall Barton" wrote:
Yes, this is a hard and fast "rule". Actually, it's just
logical that if the form is not open, any values it may have
displayed can't possible available through the form. Don't
forget that the Forms collection only contains open forms.

Either leave it alone or, instead of closing it, make it
invisible and close it in the report's close event
procedure.