• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 72
  • Last Modified:

Why will the set not update?

The record set in the attached will not update. It has a promary key and was updating until today. The form in question only pulls from one table.
Database55.zip
0
cssc1
Asked:
cssc1
  • 2
1 Solution
 
Jeffrey CoachmanMIS LiasonCommented:
Your Source for the form is a Group By Query.
By their very nature as "summary" queries, Group By queries are not update-able.

You will have to create a form based on the source table directly and update that.

JeffCoachman
0
 
cssc1Author Commented:
Thank you
0
 
Jeffrey CoachmanMIS LiasonCommented:
In looking closely at your query...
All of the fields are "Group By"...
What this means that it is basically the same as the table. (except being non-updateable.)
So my guess as to why it worked before is that someone may have inadvertently hit the "Totals" button in design view.
The query looked the same, so they may not have noticed.

So if you just "un-hit" the "Totals" button, the query should revert back to an update-able query,
Give it a try...
;-)
Totals Button
Jeff
0

Featured Post

Industry Leaders: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now