Opening reports prompts for parameter twice

  • Thread starter Thread starter heidii
  • Start date Start date
H

heidii

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
 
Did you put a condition in the report?
What happens when you put different information in the two prompts?
 
Try creating a button with the button wizard that opens the report in code.
The wizard will walk you through.
 
Back
Top