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
|
|||
|
|||
parameter query prompting multiple times
I posted this previously but the resolution didn't work and was rather
complicated. I'm wondering if there's a more simple approach. I have a parameter query in a subreport that works fine. However, when I add this subreport to the main report and execute it the parameter query prompts me four times before it finally returns the report. The Master/Child fileds are setup properly. I can't see where/why this is happening. Any ideas? -- www.Marzetti.com |
#2
|
|||
|
|||
parameter query prompting multiple times
JohnLute wrote:
I posted this previously but the resolution didn't work and was rather complicated. I'm wondering if there's a more simple approach. I have a parameter query in a subreport that works fine. However, when I add this subreport to the main report and execute it the parameter query prompts me four times before it finally returns the report. The Master/Child fileds are setup properly. I can't see where/why this is happening. Any ideas? You are being prompted each time the subreport appears in the main report. A better way is to use a form for the user to enter the parameter value. Then modify the query to refer to the text box on the form instead of using a prompt string (e.g. Forms!theparameterform.thetextbox). -- Marsh MVP [MS Access] |
#3
|
|||
|
|||
parameter query prompting multiple times
Thanks, Marshall.
Not sure what you mean by subreport prompting for each time it appears in the main report. The subreport appears only once yet it will prompt exactly 4 times. ? -- www.Marzetti.com "Marshall Barton" wrote: JohnLute wrote: I posted this previously but the resolution didn't work and was rather complicated. I'm wondering if there's a more simple approach. I have a parameter query in a subreport that works fine. However, when I add this subreport to the main report and execute it the parameter query prompts me four times before it finally returns the report. The Master/Child fileds are setup properly. I can't see where/why this is happening. Any ideas? You are being prompted each time the subreport appears in the main report. A better way is to use a form for the user to enter the parameter value. Then modify the query to refer to the text box on the form instead of using a prompt string (e.g. Forms!theparameterform.thetextbox). -- Marsh MVP [MS Access] |
#4
|
|||
|
|||
parameter query prompting multiple times
JohnLute wrote:
Not sure what you mean by subreport prompting for each time it appears in the main report. The subreport appears only once yet it will prompt exactly 4 times. I would have guessed the the subreport was in the detail section and that the main report has 4 records. Regardless of why, you are better off using a form for the user to enter the criteria. -- Marsh MVP [MS Access] |
#5
|
|||
|
|||
parameter query prompting multiple times
"Marshall Barton" wrote:
I would have guessed the the subreport was in the detail section and that the main report has 4 records. Regardless of why, you are better off using a form for the user to enter the criteria. -- Marsh MVP [MS Access] The subreport is in the detail section but the main report is only opening one related record. Thanks for the form suggestion. I'll have to experiment with that. |
#6
|
|||
|
|||
parameter query prompting multiple times
I saw this post and lit up! I'm having a similar problem with subreports
based on parameter query, however, I don't understand about the master child fields. My report is set up with one subreport (that will only return one value) in the page footer section, another 2 subreports (returning multiple values) are setup in the report footer section. All are run off of parameter queries. They all have the date (warehouse load or unload) is common. The report currently prompts 3 times to open the report. Can I make this work for my situation? Thanks, Dragon "Marshall Barton" wrote: JohnLute wrote: I posted this previously but the resolution didn't work and was rather complicated. I'm wondering if there's a more simple approach. I have a parameter query in a subreport that works fine. However, when I add this subreport to the main report and execute it the parameter query prompts me four times before it finally returns the report. The Master/Child fileds are setup properly. I can't see where/why this is happening. Any ideas? You are being prompted each time the subreport appears in the main report. A better way is to use a form for the user to enter the parameter value. Then modify the query to refer to the text box on the form instead of using a prompt string (e.g. Forms!theparameterform.thetextbox). -- Marsh MVP [MS Access] |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
parameter query not prompting for parameter | Tom Brophy | Running & Setting Up Queries | 3 | August 9th, 2005 11:31 PM |
query repeats first record multiple times | LarryWestMCSD | Running & Setting Up Queries | 0 | June 17th, 2005 12:05 AM |
Parameter query on multiple dates | Lisa | Running & Setting Up Queries | 2 | April 22nd, 2005 09:51 PM |
Too Few Parameters error Mail Merge Access Parameter Query | Tony_VBACoder | Mailmerge | 3 | September 14th, 2004 12:15 PM |
Parameter Query - Multiple Terms- 1 field - How? | LizW | Running & Setting Up Queries | 6 | August 20th, 2004 09:00 AM |