Problem wth the Input Parameters

[Ana]

Hi,

I have a report triggered by a form and connected to a stored procedure
which is not working. When a run the report as a stand alone, I'm expecting
a window asking me the desired parameters but it is not happening.

I've the following information in the DATA's Input Parameters:

@Salesman int= Forms![frmAgentDialog]![Combo_10], @F_Start smalldatetime=
Forms![frmAgentDialog]![F_Start], @F_End smalldatetime=
Forms![frmAgentDialog]![F_End]

What could be happening? The Stored procedure works fine as a stand alone
and so is the form.

TIA

Ana

 

[David Lloyd]

Ana:

I'm not sure I completely understand your circumstances, so if you could
elaborate a little more, it would be helpful. When you run the report as a
"standalone" is your form still open? Any additional information would be
useful.

--
David Lloyd
MCSD .NET
http://LemingtonConsulting.com

This response is supplied "as is" without any representations or warranties.


Hi,

I have a report triggered by a form and connected to a stored procedure
which is not working. When a run the report as a stand alone, I'm expecting
a window asking me the desired parameters but it is not happening.

I've the following information in the DATA's Input Parameters:

@Salesman int= Forms![frmAgentDialog]![Combo_10], @F_Start smalldatetime=
Forms![frmAgentDialog]![F_Start], @F_End smalldatetime=
Forms![frmAgentDialog]![F_End]

What could be happening? The Stored procedure works fine as a stand alone
and so is the form.

TIA

Ana

 

[Mike]

Hi David,
Yes, the form opens with no errors and with no data. That what surprices me
the most. What is not happening is that the Input window is not poping up
asking for the parameters.
Thank you.
Ana

 

[David Lloyd]

Ana:

I still may not be clear on exactly what is happening, however, in your
Input Parameters properties you are referencing the controls on your form.
If that form is open when you try to open the report, it will reference
those form controls for the value of the parameters and not prompt you to
supply the parameter values. This will happen even if you try to open the
report from the Report window in Access. If you close the form and then try
to open the report, you should be prompted for the parameter values.

If this is not what is happening, please try to provide additional details
as to what you are doing when you open the report.


--
David Lloyd
MCSD .NET
http://LemingtonConsulting.com

This response is supplied "as is" without any representations or warranties.


Hi David,
Yes, the form opens with no errors and with no data. That what surprices me
the most. What is not happening is that the Input window is not poping up
asking for the parameters.
Thank you.
Ana