Prev: What is the difference with these 2 expressions?
Next: Count detail only if it's different than other details in a group
From: heidii on 30 Jun 2008 14:21
Hi there:

I have a little dilemia.

I have a crosstab query that feeds my report. I have declared my
parameters in the crosstab query. This works great. I can run the
query and I am only prompted once for the parameters.

I have a macro that OpensReport from a button on my form. When it
runs the macro and opens the report I am prompted for the parameters
twice. BUT here is is... If i just go into my database window under
reports and double click my same report that is listed in my macro it
only prompts me once for the parameters. I am unsure what is
happening or what the difference is that I am missing. Any help would
be great.

Heidi
From: KARL DEWEY on 30 Jun 2008 15:04
Did you put a condition in the report?
What happens when you put different information in the two prompts?

--
KARL DEWEY
Build a little - Test a little


"heidii" wrote:

> Hi there:
>
> I have a little dilemia.
>
> I have a crosstab query that feeds my report. I have declared my
> parameters in the crosstab query. This works great. I can run the
> query and I am only prompted once for the parameters.
>
> I have a macro that OpensReport from a button on my form. When it
> runs the macro and opens the report I am prompted for the parameters
> twice. BUT here is is... If i just go into my database window under
> reports and double click my same report that is listed in my macro it
> only prompts me once for the parameters. I am unsure what is
> happening or what the difference is that I am missing. Any help would
> be great.
>
> Heidi
>
From: Roger Carlson on 30 Jun 2008 15:04
Try creating a button with the button wizard that opens the report in code.
The wizard will walk you through.

--
--Roger Carlson
MS Access MVP
www.rogersaccesslibrary.com

"heidii" <heidii(a)zirklefruit.com> wrote in message
news:fa8ad264-13d0-46ff-88e3-3d7022b30714(a)s33g2000pri.googlegroups.com...
> Hi there:
>
> I have a little dilemia.
>
> I have a crosstab query that feeds my report. I have declared my
> parameters in the crosstab query. This works great. I can run the
> query and I am only prompted once for the parameters.
>
> I have a macro that OpensReport from a button on my form. When it
> runs the macro and opens the report I am prompted for the parameters
> twice. BUT here is is... If i just go into my database window under
> reports and double click my same report that is listed in my macro it
> only prompts me once for the parameters. I am unsure what is
> happening or what the difference is that I am missing. Any help would
> be great.
>
> Heidi


 | 
Pages: 1
Prev: What is the difference with these 2 expressions?
Next: Count detail only if it's different than other details in a group