Parameter query problem

[chrisfl]

I am trying to make a parameter query using two linked tables so my colleagues can get information without having to know a lot about query criteria. For example, one of the common criteria we search by is County. When I add [County] to the criteria of the County field and run the query, the popup box doesn't appear as expected and it just opens up with the big unfiltered list. It's not a big deal because they're all familiar with data filtering, but it's strange that the thing doesn't work at all. Anyone see this before?

[ssanfu]

You have a field named "County" and you set the criteria to "County"?
To answer your question, don't use the name of an actual field. Instead of [County], use something like [MyCounty], [xCounty] or [EnterCounty].




But I would never let users run a query and be able to edit/change the data in the query. That is what forms are for.

I would have an unbound combo box in the header of a form with the row source set to

"SELECT DISTINCT County FROM TableWithCountyField"

In the after update event of the combo box I would have "Me.Requery"
The form recordsource would be the query you now have. The criteria for the "County" field would be the combo box name instead of "[County]".