Display query parameters on report

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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 said:
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])
Click to expand...

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.
 
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 said:
Little said:
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])
Click to expand...

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.
Click to expand...
 
Little said:
Can you shead some light on this make it invisible and close it in the
report's close vent procedure.
Click to expand...

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 said:
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])
Click to expand...
Click to expand...
Marshall Barton said:
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.
Click to expand...
Click to expand...
 
Back
Top