Hi, Don.
Now I want to filter these results
using a filter. When the filter is applied Access prompts for the input again
the same as when the query is first opened rather than just filtering on the
existing data.
Are you sure that there haven't been any changes to this query or its record
sources (tables and/or queries) since the database was converted to Access
2003? Sometimes a field is deleted from a table or the field name is
changed, but corresponding change is not made in the query. This would
result in a parameter prompt for the field whenever the query runs or a
filter is applied.
If this is not the case, then open the query in Design View and right-click
on the upper pane (where the tables are) and select Properties... from the
pop-up menu to open the Properties dialog window. Scroll down to the Filter
Property and delete the text in this property. Delete any text for the Sort
By Property, too. Save the query, close the Properties dialog window, and
open the query in Datasheet View.
When prompted for the ID, type it into the Enter Parameter dialog window.
After the query is open and a new filter is applied, you shouldn't be
prompted for this input again. However, when closing the query, you will be
prompted on whether or not you want to save the query if you have applied any
filters, sorts, column reordering, or column hiding/unhiding. Select the
"No" button. If you choose the "Yes" button, the last filter, sort order,
column order, and column visibility recently applied will be saved in the
query's properties, and you may get prompted next time when a filter is
applied to this open query.
HTH.
Gunny
See
http://www.QBuilt.com for all your database needs.
See
http://www.Access.QBuilt.com for Microsoft Access tips.
(Please remove ZERO_SPAM from my reply E-mail address so that a message will
be forwarded to me.)
- - -
If my answer has helped you, please sign in and answer yes to the question
"Did this post answer your question?" at the bottom of the message, which
adds your question and the answers to the database of answers. Remember that
questions answered the quickest are often from those who have a history of
rewarding the contributors who have taken the time to answer questions
correctly.
Don F said:
I have a simple query that prompts for input using criteria [Enter ID]. The
results of this query are as expected. Now I want to filter these results
using a filter. When the filter is applied Access prompts for the input again
the same as when the query is first opened rather than just filtering on the
existing data. The db that I'm using was in Access 2000 and worked ok. Now
I have it in 2003 and the second prompt appears.
Any ideas?
