Perameter Query Criteria Box opens twice

[HLCruz]

I have an interesting problem that I can't seem to resolve. I have a query
that when runs opens the "Enter Route" perameter criteria box twice. The
query results are normal, it's just an annoyance to have to enter the
criteria twice.

Below is my query SQL ... any ideas on why this may be happening and/or how
to fix it would be greatly appreciated. Thanks.

SELECT tblScheduledPickups.PickUpID, tblScheduledPickups.ResidentID,
tblScheduledPickups.RouteCode, tblScheduledPickups.MissedPU,
tblScheduledPickups.MailReceipt, tblScheduledPickups.Instructions,
tblScheduledPickups.CallerID, tblScheduledPickups.DateCreated,
tblScheduledPickups.UserCreated, tblRoutes.RouteDate, tblRoutes.RouteCity,
IIf([IntersectingStreet] Is Null,""," @ " & [IntersectingStreet]) AS
[Intersect], [ResidentID] & " " & [Intersect] AS PickUpInfo, tblRoutes.
Expiration
FROM (tblScheduledPickups INNER JOIN sysqryResidentListByZip ON
tblScheduledPickups.ResidentID = sysqryResidentListByZip.Pkey) INNER JOIN
tblRoutes ON tblScheduledPickups.PickUpDate = tblRoutes.RouteDate
WHERE (((tblScheduledPickups.RouteCode)=[Enter Route]) AND ((tblRoutes.
Expiration) Between Now() And #12/31/2020#));

 

[John Spencer MVP]

Are you looking at the query results in the query datasheet view?

Have you applied a filter or sort in that view and saved the resulting change?

Try opening the query in datasheet view and then clicking on Records: Remove
Filter/Sort. Now Save the changes to the desing (File: Save) or close the
query and save the change when asked if you want to save changes to the design.

John Spencer
Access MVP 2002-2005, 2007-2009
The Hilltop Institute
University of Maryland Baltimore County