Access form based on Paramater Query - Too many Dialog Boxes

[Jchgh2]

Can anyone shed some light on why 2+ dialog boxes come up
when I base my from on a parameter query?

For example, I have a query where the user enters criteria
for department. The dialog box comes up [Enter Department]
when the query is run.

If I base a form on the same query [Enter Department] comes
up. After department is entered another dialog box comes
up [Enter Department] and this might happen again.

Anyone?

Thanks

 

[Douglas J. Steele]

Where else would the query get the parameter's value if it didn't prompt
you?

As to why you get more than one prompt when you open the form, might the
query be used more than once in the form?