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?

Signature
Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele
(no e-mails, please!)
> Can anyone shed some light on why 2+ dialog boxes come up
> when I base my from on a parameter query?
[quoted text clipped - 10 lines]
>
> Thanks