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!

 

[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!