If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
"Enter Parameter Value" problem
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? |
#2
|
|||
|
|||
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 -- Good luck Jeff Boyce Access MVP "spacerocket" wrote in message ... 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? |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
How do I solve the "Enter Network Password" problem I have in Out. | Laura | General Discussion | 0 | August 30th, 2004 11:27 AM |
Access 2003 report parameter problem | Peter Kaufman | Setting Up & Running Reports | 0 | June 10th, 2004 01:47 PM |