why does my parameter query repeat the prompt?

N

nickaf

I have a query with three parameters. The query asks for each parameter and
then repeats itself before returning the data.
 
K

Ken Snell \(MVP\)

Probably because the query is being run more than once -- perchance, is this
query the RecordSource of a subreport or subform?
 
J

John Spencer

OR have you applied a filter or sort on the query while in datasheet view
and then saved the change? If so, open the query and select Remove
Filter/Sort from the menu and then save the query. Now try running the
query again.

--
John Spencer
Access MVP 2002-2005, 2007
Center for Health Program Development and Management
University of Maryland Baltimore County
..
 
Top