Dialog box parameters displayed in a report

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

Guest

How can I get a paramter from a dialog box to displaly in an unbound text box
in the header of my report? I have typed in the Query's criteria that refers
to the dialog form and the report gives the correct results but I get "Name"
in the unbound text boxes.
 
How can I get a paramter from a dialog box to displaly in an unbound text box
in the header of my report? I have typed in the Query's criteria that refers
to the dialog form and the report gives the correct results but I get "Name"
in the unbound text boxes.
Click to expand...

Add an unbound control to the report header.
Set it's control source to something like:

If the by "Dialog Box" you mean a form:
="For sales between " & forms!FormName!StartDate & " and " &
forms!FormName!EndDate

Change the Form and control names to whatever the actual names are
that you are using. The Form MUST still be open when the report is
run.

If by "Dialog Box" you mean a parameter prompt:
=For Sales between " & [Enter Start Date] & " and " & [Enter End date]

The text within the brackets must be identical to the text within the
brackets in the query.
 
Back
Top