query filter asking multiple times

[Nikki]

Hi,

I have a query which i have created by two linked tables. I have then based
a report on this query. In the query i have written [Enter Date] in the date
column and [Enter Shift] in the shift column. When i open the query it asks
me once to enter the date and enter the shift and seems to work. When I open
the report it asks enter date and enter shift multipl times (like it is
asking per page) What am i doing wrong?

 

[Duane Hookom]

I expect you might have a subreport or chart in your report. IMHO, parameter
prompts are never a good user interface
http://www.tek-tips.com/faqs.cfm?fid=6763. Consider using controls on a form.