Parameters/Forms/Reports

  • Thread starter Thread starter Fie
  • Start date Start date
F

Fie

Hey,

Iv created a from that passed parameter values from a query to produce
a report, only problem is that when i open the report the original
parameter boxes appear and my form dont open...

what av dont is

created query with criteria

[Forms]![frmDate]![txtStartDate] And [Forms]![frmDate]![txtfinishdate]

set the record source of the report to the query, and the record sorce
of my frmDate to the query qryBatteries.

am i doing something wrong...?

please HELP

fie
 
Hey,

Iv created a from that passed parameter values from a query to produce
a report, only problem is that when i open the report the original
parameter boxes appear and my form dont open...

what av dont is

created query with criteria

[Forms]![frmDate]![txtStartDate] And [Forms]![frmDate]![txtfinishdate]

set the record source of the report to the query, and the record sorce
of my frmDate to the query qryBatteries.

am i doing something wrong...?

please HELP

fie
Click to expand...

Start again...

Create an unbound form (an unbound form does NOT have a recordsource).

Also add 2 unbound text controls.
Set their format to a valid date format.
Name them "StartDate" and "EndDate"

Add a Command Button to the form.
Code the button's click event:

Me.Visible = False

Name this form 'ParamForm'.

As criteria in the query date field write:
Between forms!Paramform!StartDate and forms!ParamForm!EndDate

Next, code the report's Open event:
DoCmd.OpenForm "ParamForm", , , , , acDialog

Code the report's Close event:
DoCmd.Close acForm, "ParamForm"

When ready to run the report, open the report.
The form will open and wait for the entry of the starting and ending
dates wanted.
Click the command button and then report will run.
When the report closes, it will close the form.
 
Back
Top