Open the query in design and look for criteria in the criteria row that is surrounded by square brackets [ ]. If the prompts are for the exact same parameter, expect to find two query fields asking for the same thing, otherwise there is likely a second parameter in another (OR) criteria line for just one field. If you don't see anything like this, right click on the area showing the tables and choose Parameters... from the list. They could be defined there. This would also be evident in the sql view of the query - the sql would start with the word Parameters.
How you'd stop this depends on what can be done to supply the information without user interaction. Often, parameters are used to get info from the user, such as a begin and end dates for a query. More information on what is being asked for and perhaps where it might come from would be required.
Last edited by Micron; 07-30-2016 at 09:01 AM.
Reason: clarification
The more we hear silence, the more we begin to think about our value in this universe.
Paraphrase of Professor Brian Cox.