"Enter Parameter Value" problem

S

spacerocket

Hello, please help.

I have a form that contains selection criteria (combo box). There is a
Preview_Report button, and when clicked, displays the Report based on the
criteria selected. I also have a Report, that sourced its values from a Query.

I put the Report in a way that when open, the Form is opened first, and once
criteria is selected, the from is closed, and the report opens to show the
selected information.

In my trial run, I click the Form and select value, the report works fine.
However, when I click to open the report, or the query, I get a "Enter
Parameter Value" dialog. The dialog shows the message
"[Forms]![Dialog_Test]![BankID]" (which is what I entered in the Criteria
section in one of the fields of the Query).

What went wrong?
 
J

Jeff Boyce

Let's see here... (I suspect a V8 moment on the way)

You have a form that holds the parameter(s) your (query and) report needs to
run.

Your code to open the report closes the form first.

What's the (query and) report supposed to use?! <g>
 
Top