Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Cannot update a query

Status
Not open for further replies.
zahara666

zahara666

Technical User
Nov 1, 2001
78
0
0
CA
I have a query and that I need to change. So everytime I make a change and save it, all is fine. But once I run that query (the query is executed by a button on another form), it just gives me the old query - prior to making changes.

The button that runs the query has an entire function that updates the query, but I don't see why that won't let me change anything in it anymore. Any ideas?

Julie
 
Sort by date Sort by votes
After saving the query, have you closed and reopened the database? You may even want to Compact and Repair the database. Terry L. Broadbent - Salt Lake City, UT
Home of the 2002 Winter Olympics (Feb 8-24)
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

btamsgn
  • Locked
  • Question
how to create a crosstab query 1
Replies
1
Views
184
dhookom
dhookom
combo
  • Locked
  • Question
'Wrong property setting' message in query 1
Replies
2
Views
182
combo
combo
Moss100
  • Locked
  • Question
Append query dropping leading zero 2
Replies
4
Views
180
Andrzejek
Andrzejek
TheresAlwaysAWay
  • Locked
  • Question
Union query provides different reslt than when summing the combined queries individually 1
Replies
12
Views
188
TheresAlwaysAWay
TheresAlwaysAWay
JK Dutta
  • Locked
  • Question
requet for form an access query for report
Replies
2
Views
180
dhookom
dhookom

Part and Inventory Search

Sponsor

Back
Top