Office 2007 - rename query problem

[finster26]

I'm using Office 2007 - Access. I rename a working query. I run the query but
it asks for a paramater which has the old name it. For example:
"qStreet.field1". The new name of the query name is "qStreetNew". The
correct field is "qStreetNew.field1". I renamed it back to the old name and
it works and doesn't ask for the parameter. Can't seem to find out why this
is happening.

 

[Gina Whipp]

finster26,

I have seen this happen when after you rename the query you don't check the
OrderBy field. While the query has been renamed the OrderBy still says
Order By: qStreet.field1. Fix that by either putting in the correct name of
the query of simply deleting what is on the OrderBy line.

--
Gina Whipp
2010 Microsoft MVP (Access)

"I feel I have been denied critical, need to know, information!" - Tremors
II

http://www.regina-whipp.com/index_files/TipList.htm