Subreport repeating parameter

[lansel]

I have a main report with a parameter of employee number. I also have a subreport with a parameter of employee number. When I try to open the report, the parameter "What employee #" is repeating several times; some times as many as seven times. It also asked again if there is a second page to the report. How can I fix this? I am linking the subreport to a table in a different database.

Thanks!

 

[Pat Hartman]

You don't need the parameter in the subreport's query. The master/child links will take care of synchronizing the main report and subreport.

If you are still having trouble with multiple prompts, you'll need to switch to referencing a form field rather than prompting to obtain your parameter. In some cases the report needs to open a query more than once. In these cases, it will prompt each time it needs to open the query. Referencing a form field will resolve this issue.

Where YourField = Forms!YourFormName!YourFieldName;
rather than
Where YourField = [Enter value];

 

[lansel]

Thanks for your reply. When I eliminated the parameter from the Subreport, ALL employees' information was listed in the subreport instead of just the one in the main report.

I will try the form.

Thanks!!

 

[lansel]

I tried the form and it works great! Thank you very much.

Linda

 

[bookingdb]

I did try this and it worked the first time and brings the form up when you open the query. However, on all subsequent times it just brings up a parameter query.... Any ideas about this? Thanks!

 

[Pat Hartman]

The query parameter is caused by a field name that Access can't find. Either it is a typo or a field whose name was changed. If you can't find the erroneous field in the queries, check the form's sorting and filtering properties.